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.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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
    3 years ago

    Hi Jim,

     

    I have a further question on this topic.

     

    Now  I have result 1 based on measure 1/column1and result 2 based on measure 2/column2. I need to calculate result 3 = Result 1*result 2.

    Result 3 needs to be presented against candidatevalue group. Is it possible?