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
    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]
    )
    )

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.