Trying to create an attendance percentage from a visual output

[Anonymous]

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!

[amitchandak]

@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

[Anonymous]

Thanks. The divide function was what I was after. I was trying to do the math without it