Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to implement DAX formula for this : if column F- column G=column H-column I=True else false

 
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Please try to create a new column like below:

    Match = 
var f1 = 'Table'[PIR Count]-'Table'[PDR Count]
var f2 = 'Table'[GIR Count]-'Table'[GDR Count]
return IF(f1=f2,TRUE(),FALSE())

     

vigneshahob's avatar
vigneshahob
Frequent Visitor
4 years ago

You will have to decide if this should be a column or a measure. 

 

Measure would aggregate and so the filter context plays a key role. 

 

If you would like every row to be flagged "Visually", then you will have to create a column not a measure.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I am planning to create a calculate column but its not working