Forum Discussion

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper 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!Av69y58QJYzRjyMDJ5UITXVP0Sgs

 

 

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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's avatar
      ilcaa72
      Icon for Helper IV rankHelper IV
      8 years ago

      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's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity 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