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,
I have four data sources loaded that allow me to create a dashboard. On one of the visuals I have list of sites with the amount of people that have atteneded using filters. I am trying to create a percentage sum of total population that have attended each site(25 people have gone in, total staff at that site is 100. 25% have visited) however to do that I need to build the total number of staff for each site to complete the percentage math.
There are two options. I can use one table that has the location each person works (so go count each occurance of the site name in each line of the visual, then use the varible to create the math) or just point to the a cell in another table that has the count of staff. To do that I would still need to match each line in the visual then have PowerBI search for the site name in table B and finally go to cell that has the number of staff.
Frankly - I am lost and have no idea. I have tried some variations of COUNT,SUMMARIZECOLUMNS etc. Any help would be great.
Tks!
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
You can try measures like
divide( countrows(Table), calculate(countrows(Table), allselected()))
Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37
Thanks. The divide function was what I was after. I was trying to do the math without it
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |