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 all,
Could you please help me to get the measure for the to get the total number of accounts for each region with A&B slicers applied on page? Use it to calculate the % of actual vs. total accounts with A&B applied.
Appreciate your help
Here the PBIX file:
https://file.io/EIbffHydjc8d
Thank you. Just updated with the link to PBIX file.
My need is to keep show the percentage of A B C D with Weekly/Monthly already applied
(denominators fixed = 179, 357, 930)
So if I change the state, the % will show as a ratio to these numbers (% of A in that state on total A with Frequency applied).
Thank you so much.
@Anonymous , Based on what I got
Measure = CALCULATE(COUNT(Table[Region]), Filter(allselected(Table), Table[A] = max(Table[Table A]) ))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |