Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
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
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 @Anonymous
Sorry, but I lost you.
Better share some data. Alos, the initial status and expected results.
Thanks
A
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |