Forum Discussion

madan27's avatar
madan27
Frequent Visitor
9 years ago

Getting visual level filter condition in DAX

Hi,   I am trying to create a new Measure Column using DAX, How can I add the Visual level filter condition value to the DAX.   Thanks, Abinesh
Need Help
Show and Tell
Tips and Tricks
madan27's avatar
madan27
Frequent Visitor
9 years ago

Thanks v-huizhn-msft. I got the result using FILTERS.

 

I need to get the "specificr value" from "Visual Level Filter" condition instead of keeping static.

Table[column]="specificr value"

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi madan27,

The "Visual Level Filter" comes from separate Table? Can you create a measure to get the value? Like "selectvalue=CALCULATE(Max(Table[column]),ALLSELECTED(Table))". If it is, please replace it to filter in DAX.

Table[column]=[selectvalue]

Thanks,
Angelia