Forum Discussion

DavidGlover's avatar
DavidGlover
New Member
4 years ago
Solved

Filter measure by another column data

Hi, I have a simple measure that works like the below:

 

SUMDenominators = sum(SalesData[Denominator (rounded)])
 
I need to be able to filter this by another column within the same table entitled 'Year' which has values of 2019/20 or 2020/21 - can anyone please provide the solution to amend the above in order that it filters column 'Year' for value '2019/20' please? 
 
Thank you! 
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    DavidGlover TRy this:

    SUMDenominators = CALCULATE(SUM(SalesData[Denominator (rounded)]),TableName[YearColumn] in {"2019/20" ,"2019/21")

     

1 Reply

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    4 years ago

    DavidGlover TRy this:

    SUMDenominators = CALCULATE(SUM(SalesData[Denominator (rounded)]),TableName[YearColumn] in {"2019/20" ,"2019/21")