I am working through a dashboard within power BI and we are running into the following problem:
We are attempting to look up the values on a matrix table:
National sales performance 99% 100% 101%
99% 100% 99% 98%
100% 101% 100% 99%
101% 102% 101% 100%
I first unpivoted the information so that for every National performance there was a unique value for Personal performance and the payout multiplier.
I then looked to filter the table and run a lookup on the data table using the following dax equation.
- Filter unpivoted table by the National performance column using "Performance %"
- Look up the payout multiplier, using the Personal "Performance %"
Filtered Lookup = CALCULATE(LOOKUPVALUE('Grid - Viberzi Capped 150'[Payouts],'Grid - Viberzi Capped 150'[Personal],[Performance %]),Filter(All('Grid - Viberzi Capped 150'),'Grid - Viberzi Capped 150'[National] = [Performance %]))
The above equation is not providing a result.
I still can't understand your requirement and table structure. But I'm pretty sure it's not possible to "lookup" value with filter condition.
Can you share some sample data so that we can see if there's other approach?
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!