Forum Discussion

AmineGatou's avatar
AmineGatou
Frequent Visitor
4 years ago

Filter Card using Categorical measures

Hey everyone, I've been stuck on this problem for quite a while now. I have created a table named "KPI" containing these values. ( These values are the expected result of a certain measure) S...
Need Help
Show and Tell
Tips and Tricks
Arul's avatar
Arul
Super User
4 years ago

Hi AmineGatou ,

 

Please ellaborate your expectation more in detail. So that i can try to figure out a way to help.

 

Thanks,

Arul

AmineGatou's avatar
AmineGatou
Frequent Visitor
4 years ago

All right the idea is to filter my data using the "diag YTD/Y-1" measure and its formula is : 

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

if(and([LYTotCA]<=0,[TotCA]>0),"NEW",if(and([LYTotCA]>0,[TotCA]<=0),"LOST",if(and(and([LYTotCA]>0,[TotCA]>0),([LYTotCA]>[TotCA])),"DEC",if(and(and([LYTotCA]>0,[TotCA]>0),([LYTotCA]<[TotCA])),"INC","STB"))))

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

So I got the idea to create a table named "KPI" that contains all the values possible of the measure as rows. Then I created another measure that compare the Selected value from the KPI table and the value of DiagYTD/Y-1 Measure, this way my table was filtered but the cards don't filter. So I need a solution to filter those cards as well. 

I hope everything's clear now.