cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dohscott New Member
New Member

Fitler + look up value

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%

Personal Performance

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.

 

Objective:

- 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.

 

Thank you

 

1 REPLY 1
Moderator v-sihou-msft
Moderator

Re: Fitler + look up value

@dohscott

 

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?

 

Regards

 

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,292)