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 16 days ago
    Edited by SADDIKI Nassim 16 days ago
    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
    ------------------------------