Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a set of data which I want to filter by month, so it shows a snapshot for the month for entities however shows the latest grading. So all entities for April 2021 however latest grading which could have been in April 2020. so in the image below if i filter on March 21 table on left then I want entity A and the latest grading of Good from table on the right to show in the dashboard.
Solved! Go to Solution.
Hi @cm99 ,
Create a measure as below:
Measure =
var _entity=CALCULATE(MAX('Table1'[Entity]),FILTER('Table1','Table1'[Month]=SELECTEDVALUE(Table1[Month])))
Return
IF(MAX('Table2'[Entity])=_entity,1,0)
Then put the measure in the filter pane and select is 1:
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @cm99 ,
Create a measure as below:
Measure =
var _entity=CALCULATE(MAX('Table1'[Entity]),FILTER('Table1','Table1'[Month]=SELECTEDVALUE(Table1[Month])))
Return
IF(MAX('Table2'[Entity])=_entity,1,0)
Then put the measure in the filter pane and select is 1:
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |