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 Friends,
Please assist me with this issue I can't seem to solve:
So as you can see in the table, I have customer/franchisee names and below that are the stores they have. I created a disjointed table which shows "red", "amber" and "green" which is actually the grouping of the stores stly growth eg. if < 0, "red", < 0.5, "Amber" and so forth. The slicer "display" will show only stores that falls within the selected range.
The store count seems to appear irrespective of whether they are in any of the color groupings. I want to do a count of the stores that only falls within each of the respective grouping.
DAX used for the "Display" slicer to work is:
Note that the measure "Colour Filter" is actually a YOY growth measure
Please let me know what code I can use for the dynamic count of stores by selecting the different colour diplay slicer.
Thanks all!
Solved! Go to Solution.
Try:
Count of Store =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Cutsomer name] ),
FILTER ( Table, NOT ( ISBLANK ( [COLOR FILTER] ) ) )
)
Proud to be a Super User!
Paul on Linkedin.
Try:
Count of Store =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Cutsomer name] ),
FILTER ( Table, NOT ( ISBLANK ( [COLOR FILTER] ) ) )
)
Proud to be a Super User!
Paul on Linkedin.
Thank you sir! Appreciate the help. This worked perfectly:)
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |