Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
Please help me to solve this. I have a table report which has two text columns and 5 DAX measures.
Text Columns : Cutomer No. , Customer Name
Measures : Total, Age 1-20, Age 21-40, Age 41-60, Age 61-80
I have created a table report. In this report, i need to filter out all the rows where there is 0 for all the measures.
For example i want to filter out Customer BBB (row no. 2) from my table.
Customer No. | Customer Name | Total | Age 1-20 | Age 21-40 | Age 41-60 | Age 61-80 |
11 | AAA | 13692.50 | 321.63 | 0 | 7938.52 | 5432.35 |
22 | BBB | 0 | 0 | 0 | 0 | 0 |
33 | CCC | 17341.48 | 521.63 | 3448.98 | 7938.52 | 5432.35 |
44 | DDD | 0 | 9368.32 | 2345.12 | 0 | 4458.98 |
I know how to create a customer filter for multiple columns. But in this case i have multople measures.
Please help me to find the solution for this.
Thanks
Solved! Go to Solution.
Try creating another measure like the one below and use that as a visual filter for your table
Measure = IF([Age 1-20]=0, IF([Age 21-40]=0, IF([Age 41-60]=0,IF([Age 61-80]=0,0,1),1),1),1)
Try creating another measure like the one below and use that as a visual filter for your table
Measure = IF([Age 1-20]=0, IF([Age 21-40]=0, IF([Age 41-60]=0,IF([Age 61-80]=0,0,1),1),1),1)
Hi Thejeswar,
Thank you so much for your help.
Please let me know do i need to create this measure as of Bollean type (true/false) or as whole number.
As a visual filter ,i have selected 'Show me all the iteams when value is 1".
Please confirm if my understanding is correct
Thanks.
Yes. You can create it as either a Whole Number or a Boolean.
Yes you will have to set visual filter as equating to 1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |