The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.