How would you compare two columns in a Dax query from different dimension tables in the live cube?

[shushank]

Hi All,

I have one scenesio where I have to compare one dimension table data with another dimension table data in a Dax on live cube hence i cant add any calc column.

For example

Calculate(totalrevenue, A+1 =B)

This is just an example to illustrate my scenerio.

Thanks

[Greg_Deckler]

@shushank Well you would need to use a measure then.

[shushank]

I meant to create a measure only. How would you write a measure for that ?