Forum Discussion
DAX Formula Help Needed - Retrive Non Slicer Values having same Measure Value as Slicer Value
hi, uk17487
For your requirement, you could try this way:
Step1:
Add a fact C2 table as a slicer, (you could not use original C2 as a slicer)
Step2:
Use this formula to create a measure
Measure = VAR _table=CALCULATETABLE(VALUES('Table'[C1]),FILTER(ALLSELECTED('Table'),'Table'[C2] = SELECTEDVALUE(C2[C2]))) return CALCULATE(MAX('Table'[C2]),FILTER('Table','Table'[C1] IN _table))Step3:
Drag this measure into visual level filter and set is not blank
Result:
and here is pbix file, please try it.
Best Regards,
Lin
hi, uk17487
For your requirement, you could try this way:
Step1:
Add a fact C2 table as a slicer, (you could not use original C2 as a slicer)
Step2:
Use this formula to create a measure
Measure = VAR _table=CALCULATETABLE(VALUES('Table'[C1]),FILTER(ALLSELECTED('Table'),'Table'[C2] = SELECTEDVALUE(C2[C2]))) return
CALCULATE(MAX('Table'[C2]),FILTER('Table','Table'[C1] IN _table))
Step3:
Drag this measure into visual level filter and set is not blank
Result:
and here is pbix file, please try it.
Best Regards,
Lin
Hi Lin,
It worked perfectly.
Thanks for your help.
Hi,
If the main table is going to be connected to other supporting tables and the reports had to be created using the slicer of the main table column C2, then what do we tweak in the current solution to handle the same. As in current solution, we are using C2 table as the slicer and not the main table column. My apologies I did not forsee that model can have more than one table. Kindly advise.
Please let me know if I should start a new post.
Thanks
Uday
hi, uk17487
Just for your current requirement(Retrive Non Slicer Values having same Measure Value as Slicer Value), It could not use the main table column C2 as a slicer.
And for your other requirement, you could share your sample report for us to have a test or start a new post and add the other conditional.
Best Regards,
Lin