Forum Discussion

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

Tips and Tricks

Super User

4 years ago

Hi AmineGatou ,

Do you have relationship enabled between the client data table and KPI table?

Thanks,

-Arul

AmineGatou
Frequent Visitor
4 years ago
Hi arul, no there is no relationship beetween them , since the KPI table only have two columns the KPI'S one has values that are expected to be returned from a measure ( Find it below)

DiagArticleCA N/N-1 = 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"))))

I'm really stuck on this.
- 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
    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.