lookupvalue based on page level filters

[cypresstj]

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? 

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

Hi,

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

Thanks

A

[Anonymous]

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

[Anonymous]

Hi @Anonymous 

Sorry, but I lost you.

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

Thanks
A