Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago

how to connect filter threshold table to Matrix

hello   i have a small threshold i created that i would like to use as a slicer for my Matrix table... i just dont know how to "connect the 2"   can someone assist?   thanks  https://1drv.ms/u/s!...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi ilcaa72,

 

We can create the measures as below to meet your requirement.

 

 

1 = IF([1 month MatchRate Delta]>=SELECTEDVALUE(Threshold[MatchRate Threshold]),[1 month MatchRate Delta],BLANK())
3 = IF([3 month MatchRate Delta]>=SELECTEDVALUE(Threshold[MatchRate Threshold]),[3 month MatchRate Delta],BLANK())
6 = IF([6 month MatchRate Delta]>=SELECTEDVALUE(Threshold[MatchRate Threshold]),[6 month MatchRate Delta],BLANK())

 

 

Also please refere to the pbix as attached.

 

https://www.dropbox.com/s/pl28jdu6vuxvbvn/testDifference-mod1.pbix?dl=0

 

Regards,

Frank

ilcaa72's avatar
ilcaa72
Helper IV
7 years ago

Thanks Frank, but I dont want to hide the data point, i am trying to filter the table to only show values >= the selected threshold

 

your measures remove the data point.  i am trying to filter a table to just show Bank ID which contain a value > = threshold