Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Comparing Multiple Values against a single Employee in a Table and performing Filtering

Hi, I have two datasets that I have merged with each other. The merged dataset looks like this,    Emp_ID Resource_Name Primary Code IsProjection 1 Haris A FALSE 1 Haris A TRUE ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

Place the following measure in the filter pane of tge table visual, select"is not blank" then apply the filter 

FilterMeasure =
COUNTROWS (
FILTER (
VALUES ( 'dataset'[Emp_ID] ),
[Projected Projects] <> [Submitted Projects]
)
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    tamerj1 
    Thank you so much! This worked like a charm! 
    I was trying to do this same thing by using simple IF Condition, 

     

    If ([Projected Projects] = [Submitted Projects], TRUE(), FALSE()) 

    But that was just not working for me, for a reason I don't get. Thank you however for providing me a much more effective and a working approach! Really appreciate it.