Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
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())
Also please refere to the pbix as attached.
https://www.dropbox.com/s/pl28jdu6vuxvbvn/testDifference-mod1.pbix?dl=0
Regards,
Frank
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |