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

[Anonymous]

[V-lianl-msft · Accepted solution]

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]

IF ( 'table'preinsert + 'table'gginsert - 'table'predelete - 'table'ggdelete = 0, true, false)

If that doesn't work, can you share what error you are seeing?

[vigneshahob]

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]

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