cancel
Showing results for
Search instead for
Did you mean:
Helper IV

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

4 REPLIES 4
Super User IV

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.

---------------------------------------

@ me in replies or I'll lose your thread!!!

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helper IV

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))
)```
Community Support

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Helper IV

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

## Helpful resources

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!

#### Check it Out!

Click here to read more about the December 2020 Updates!

#### Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

#### Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors