Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |