Lookup corresponding value to populate measure, to then use in a second measure

[shaunparsons66]

Hello all,

I have built a very simple dashboard that shows attendance at a selection of about 50 offices, spread across the world.

When you select a site from the drop-down slicer, it shows the headcount of the site, the attendance, and the % attendance (attendance / headcount). All very simple and easy!

However, I want to display a separate visual that displays the % attendance for the region based on whatever site is currently  selected. So for example, if 'Site Office 1' is selected (which is in EMEA), I want to show the overall % attendance for all sites in EMEA. Same for sites in APAC and Americas when a site from these regions is selected.

I have tried and failed to do this - when I hard-code in the region into the measure (= "EMEA"), it works fine. But when I try to target a measure I have created, it completely ignores it and just gives me global numbers.

Any help would be hugely appreciated. I have uploaded the PBI file to Dropbox at the below link:

https://www.dropbox.com/s/84o62ja52oejjty/Benchmark%20Test.pbix?dl=0

[parry2k · Accepted solution]

@shaunparsons66 not sure if I followed you question, but try this measure:

Regional Attendance = 
VAR __region = VALUES ( Sheet1[Region] )
RETURN
CALCULATE([% Attendance], ALL ( Sheet1 ), __region ) 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[shaunparsons66]

Thank you - this works perfectly! I need to understand variables more, so this is super helpful.