how to connect filter threshold table to Matrix

[ilcaa72]

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!Av69y58QJYzRjyMDJ5UITXVP0Sgs

[Greg_Deckler]

Generally, you would grab the MAX of your threshold in your measures and if it is more/less than the threshold, return 0 or BLANK(), otherwise calculate as you are right now.

[ilcaa72]

so in the measure which generates the values of the matrix, wrap a if and a Max

here is my measure i actually have 3 diffrent measures on values in my Maxtrix...., not 100% how this is accomplished based on your explanation...  can you write a pseudo formula based on your method?  thanks

1 month MatchRate Delta = 
IF(ISBLANK(DATEADD(test[Date],-1,MONTH)),BLANK(),
CALCULATE(sumx(test,test[MatchedRate]), filter(all(test[Date]), test[Date] = max(test[Date])))
- 
CALCULATE(SUMX(test, MAX(test[MatchedRate])), DATEADD(test[Date],-1,MONTH))
)

[v-frfei-msft]

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]

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