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.
Solved! Go to Solution.
Thank you, @DataInsights !
It is not displaying the exact percentages while using your formula. I will recheck later. Some filters are also applied, and it might be the cause.
I have already got the job done with a mere tweaking.
Try this measure. It uses ALLSELECTED, instead of ALL.
Distribution =
DIVIDE (
DISTINCTCOUNT ( Table1[Brand Availability] ),
CALCULATE ( DISTINCTCOUNT ( Table1[Store ID] ), ALLSELECTED ( Table1 ) )
)
Proud to be a Super User!
Thank you, @DataInsights !
It is not displaying the exact percentages while using your formula. I will recheck later. Some filters are also applied, and it might be the cause.
I have already got the job done with a mere tweaking.
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 |