cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
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
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!




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))
)

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())

Capture.PNG

 

 

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.

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
secondImage

Happy New Year from Power BI

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

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

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

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