Forum Discussion

Naveen_SV's avatar
Naveen_SV
Helper IV
7 years ago
Solved

How to Create Filters in Matrix when user needs column name needs to be filtered

How can i create the Filters for the column which is given please see my below screen shot. when the columns are using Numbers. I want a filters for Male and Female is that possible.
Need Help
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Naveen_SV 

    You may create a table2 as slicer.Then create 3 measures like below:

    Female_1 = IF({"Female"} in VALUES(Table2[Slicer]),SUM(Table1[Female]))
    Male_1 = IF({"Male"} in VALUES(Table2[Slicer]),SUM(Table1[Male]))
    Population_1 = IF({"Population"} in VALUES(Table2[Slicer]),SUM(Table1[Population]))

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Naveen_SV 

You may create a table2 as slicer.Then create 3 measures like below:

Female_1 = IF({"Female"} in VALUES(Table2[Slicer]),SUM(Table1[Female]))
Male_1 = IF({"Male"} in VALUES(Table2[Slicer]),SUM(Table1[Male]))
Population_1 = IF({"Population"} in VALUES(Table2[Slicer]),SUM(Table1[Population]))

Regards,

Naveen_SV's avatar
Naveen_SV
Helper IV
7 years ago

Your amazing thanks for this