Compare values of two measures

[schoden]

Hi All, 

I have two measures from two different table- both measures calculates sum of value with condition applied.

In the end I want to check if values from those two measures are equal or not. 

Final check = IF( Grand Margin== Margin , 1, 0)

It doesnt really compare the values correctly.

Please help.

Cheers :D. 

[amitchandak]

@schoden , Try like

Final check = Sumx(values(Oppurtunity_recID), IF( [Grand Margin] = [Margin] , 1, 0))

Assumed [Grand Margin] , [Margin]  are measures

[schoden]

Hi @amitchandak 

It seems it it not iterating at row level.

[v-shex-msft]

Hi @schoden,

AFAIK, measure formula results not changed by hosted tables. Did these measure formulas extract values from the same table field? If this is a case, I think you need to create an unconnected table and modify one of your formulas to use this new table field in source or these measure formulas will get the same result from the filter. (Dax format can't get different results from these same table field)

Regards,

Xiaoxin Sheng

[schoden]

@v-shex-msft  Hi , 

I have two tables connected with one-to- many relationships. Each table has one measure and I am trying to compare those two measure values. 

[v-shex-msft]

HI @schoden,

Can you please share pbix file with some dummy data to test?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@schoden , is opportunityrow_id is at the lowest level?

If not use that. Also are the avaiale as column at in table , you can try a colum like

Final check =  IF( [Grand Margin] = [Margin] , 1, 0)

[schoden]

Yes @amitchandak 

The first one was a new column , 

using SUMX - I changed to measure. 

both showed same.