Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Mutually Exclusive measure

I have a table that looks as follows:

 

 

Now I bring a simple card visual with count of pernr:

 

I choose Ready now as Yes in filter, and it gives me 2 which is correct. Because there are 2 people under Ready Now with Yes.

 

But Now when I choose Yes in 1-2 Year roles. it changes to 1. Because it does Ready Now = "yes" AND 1-2 yEAR = "Yes"

 

 

Is there a way to make it do "Ready Now" = "yes" OR 1-2 Year = "Yes" so that it gives 3? 

 

I cant have a measure just for this criteria as yes because there are other filters too that users would play with.

 

Thank you!

 

 

Need Help
Show and Tell
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous 

     

    Try this.

     

    Unpivot the Columns

     

    Filter on the new "Attribute" Column and make a distinct count on the PERNR

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

1 Reply

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous 

     

    Try this.

     

    Unpivot the Columns

     

    Filter on the new "Attribute" Column and make a distinct count on the PERNR

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.