Comparing two filtered text fields in the same table and displaying the differences

Question

Hi there! I have two calculated text visuals (Source and Target) based on the same column (Version). They are both sliced differently. I want a third calculated column to display the differences from slicked Target to the sliced Source. The data and what I'd expect looks like this. I can't seem to figure out the correct DAX.&nbsp;[Source]&nbsp; &nbsp; &nbsp;[Target]&nbsp; &nbsp; &nbsp;[Difference]---------&nbsp; &nbsp; &nbsp;---------&nbsp; &nbsp; &nbsp;------------|1111|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; |0000|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;|1111||2222|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;|2222||3333|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;|3333||4444|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;|4444|&nbsp;Thanks!

robertsbm · Answer

Hi there! I have two calculated text&nbsp;visuals based on the same column (table "Source" and table&nbsp;"Target"), both filtered differently. I want a third calculated column to display the differences from Target to Source. The data and what I'd expect looks like this.&nbsp;[Source]&nbsp; &nbsp;[Target]&nbsp;&nbsp;&nbsp; &nbsp;[Difference]--------&nbsp; &nbsp; --------&nbsp; &nbsp; &nbsp; ------------|1111|&nbsp; &nbsp; &nbsp; |0000|&nbsp; &nbsp; &nbsp; &nbsp; |1111||2222|&nbsp; &nbsp; &nbsp; |2222||3333|&nbsp; &nbsp; &nbsp;&nbsp;|3333||4444|&nbsp; &nbsp; &nbsp;&nbsp;|4444|&nbsp;Thanks!

chandeepchhabra · Answer

Can&nbsp;you elaroate the data a little more, may be share it

hardik · Answer

first of all change the data type of the columns from gtext to integer for subtraction by clicking on the modelling tab and later on write a dax query by creating a new column.Hope this helps !

robertsbm · Answer

Thanks for your reply. I'll try adding more detail. There's a fourth table involved called environment. I have a slicer of it on the report twice. The first slicer (ENV1) affects the Source table, and the second slicer (ENV2) affects the Target table. I'm having trouble getting the difference (from Source and Target) to display in a third column.&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;(w/ENV1 Filter)&nbsp; (w/ENV2 Filter)[ENV1]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [ENV2]&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;[Source]&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;[Target]&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;[Difference]--------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;---------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ---------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-------------|Dallas|&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;|Chicago|&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;|1111|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;|0000|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|1111|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;|2222|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;|2222|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;|3333|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;|3333|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;|4444|&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;|4444|

v-chuncz-msft · Answer

robertsbm,
&nbsp;
You may try&nbsp;EXCEPT Function&nbsp;and refer to this post.

Forum Discussion

Comparing two filtered text fields in the same table and displaying the differences

6 Replies

Related content

Compare different tables

Comparing values between different tables

Compare two columns in different tables

Display Differences Between 2 Matrices

Display latest data compared to earliest data