Forum Discussion

e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
5 years ago
Solved

2 Data in same visual with different filters applied

Hi all,   I have 2 measures, the first applies filter 1 but not filter 2. The other applies filter 2 not filter 1. 2 measurs have to be shown in the same visualization. Column1 for filter 1, and ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, e2liu77 

    Please correct me if I wrongly understood your question.

     

    Can you try the below measure?

     

    Result1 =
    CALCULATE(
        [a measure 1],
        Table[column1] IN allselected (CandidateValue [Value])
    )
     
     
    Result2 =
    CALCULATE(
        [a measure 2],
        Table[column2] IN allselected(CandidateValue [Value])
    )
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
5 years ago

Hi Jim, Yes, it works! Thanks for helping me!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.