Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Measures bases on group by two attributes from two different dimension tables

  • 1.  Measures bases on group by two attributes from two different dimension tables

    Posted Jul 24, 2022 04:03 PM
    Edited by SADDIKI Nassim Jul 24, 2022 06:59 PM
    Hello,

    I would like calculate a measure that based on two dimension tables Material & Resource, I.

    I used this formula : 

     Production = 
    CALCULATE( 
                SUMX(D_SNP_PDN_VMI,DIVIDE(D_SNP_PDN_VMI[QTY],D_SNP_PDN_VMI[CNV])),
                ALLEXCEPT(R_Mat_Mea,R_Mat_Mea[(Mat_COD]),
                AllExcept(R_APO_LCT,R_APO_LCT[(Loc) Location])
              )
    but it seems the formula doesn't work because I dontdon't have a relationship between Mat_Mea tableMat_Mea and RSCRSC table.
    Anyone can have an idea how we deal with it?
    regards



    ------------------------------
    SADDIKI Nassim
    Consultant
    ------------------------------