DAX Period vs Period - Show only items with variance

[joe321]

I have three measures:

1. Total Current Qtr
2. Total Last Quarter
3. Difference between Current and Last Quarter

It is working as intended, but I would like to modify it so it only displays only if there is a variance. As of now, if there isn't a variance, it displays all the detail rows that are the same.

I can filter the pivot to achieve this, but I want to remove that step from potential end users.

 

[Salle]

Sounds like a simple IF function would do it:
IF([1]=[2],BLANK(),[1]-[2])

 

[joe321]

Thanks. That solved my issue.