Forum Discussion

norbi's avatar
norbi
Helper I
8 years ago
Solved

Using Ratios between two tables for output depending on Filter

Hi,   I would truly appreciate some assistance with a challenge I have been struggling with in Power BI. I would like to get the Customer_Number ratios in Table_1 to split the Year_1, Year_2 and Ye...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi norbi

 

Please see the revised file here

 

Lets use these MEASURES

 

%age =
DIVIDE (
    CALCULATE ( SUM ( Table1[Customer_Numbers] ) ),
    CALCULATE ( SUM ( Table1[Customer_Numbers] ), ALLSELECTED ( Table1[Shop] ) )
)

 

Tar1 =
[%age]
    * CALCULATE (
        VALUES ( Table2[Year_1] ),
        FILTER (
            ALL ( Table2 ),
            Table2[Customer_Type] = SELECTEDVALUE ( Table1[Customer_Type] )
        )
    )
  • norbi's avatar
    norbi
    Helper I
    8 years ago

    Zubair_Muhammad Thank you very much it works, it is truly appreciated.