cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cypresstj
Regular Visitor

lookupvalue based on page level filters

Hi,

For the <search value> parameter in the lookupvalue function, I wonder if it's possible to link it to a page level filter, so the value will change dynamicially based on results of the filter? 

1 ACCEPTED SOLUTION
AClerk
Solution Sage
Solution Sage

Hi @cypresstj 

I believe it is possible.

Create a measure with the filter values you would like to use. then use it in the LOOKUPVALUE() function.

Provide some sample data, maybe we can figure out how to do it based on it.

Thanks!
A

View solution in original post

5 REPLIES 5
AClerk
Solution Sage
Solution Sage

Hi @cypresstj 

I believe it is possible.

Create a measure with the filter values you would like to use. then use it in the LOOKUPVALUE() function.

Provide some sample data, maybe we can figure out how to do it based on it.

Thanks!
A

View solution in original post

cmcd21
Frequent Visitor

Hi A

 

How do i create a measure for the filtered values?

 

I have a dashboard that uses a page level filter (CategoryName from a SQL table) to filter across multiple tables.

I have an Overall Score table that looks up values from other tables and I want this to be dynamic, so when i change the category, the contents of the Overall Score table changes

 

Thanks

 

Hi,

It is better if you share some sample data or you PBIX.

Thanks

A

cmcd21
Frequent Visitor

 

The page level filter is chosen from the Category table below.

CategoryID CategoryName
1          Soccer
2          Basketball
3          Netball

I have an ContentAnalysis table that calculates the average of rows from a SQL table and this average is displayed as a Donut Chart

 

I have an Match table that reads a figure from anoter SQL table and is displayed as a Donut Chart

 

I have an Overall Score Table but currently am manually entering in the figures via SQL. I want the table to be able to read these figues automatically and be able to change the figures based on what category is selected as the page filter.

 

 

CategoryName 	AssuranceMetric   OverallScore
Soccer ContentAnalysis 0.79
Soccer Matching 0.55

 

So far I've tried this code but am getting an error:

ScoreDynamic = 
IF(PowerBI_Overall_Score[Assurance Metric] = "ContentAnalysis", AVERAGE(ContentAnalysisResults[PassFail]), 
IF(PowerBI_Overall_Score[Assurance Metric] = "Matching", LOOKUPVALUE(PowerBI_Matching[Percentage Matched],PowerBI_Matching[Category], PowerBI_Overall_Score[Category],
   )))

So my two questions are:

How do i get the CategoryName in the Overall Score Table to change based on the page filter?

How do i get the Overall Score Table to change the scores based on the page filter?

 

Thanks

 

Hi @cmcd21 

Sorry, but I lost you.

Better share some data. Alos, the initial status and expected results.

Thanks
A

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!