'I want to find difference between two CARDS in POWER BI, I can't use measure because i applied filters on the cards
I have posted the images, with the filter i have applied to the rows. I would get the difference value as 10 .
Solution 1:[1]
You could create measures for each individual card that includes the filters that you added to them. And then you would just have to subtract the two measures from each other to get your last value.
Solution 2:[2]
This link offers guidance on how to compare two filtered cards. Summary:
- Re-create table twice for each set of cards (How to create calculated table).
- Create a measure for each card, e.g. Measure1 = CALCULATE(SUM(TableForCard1[Col]))
- Create a measure for the difference, e.g. Diff = [Measure1]-[Measure2]
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | ZachMann |
| Solution 2 | Erik |