Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all,
I have a dataset table like the one below:
ID | Initial Status | Final Status |
a1 | x | x |
a2 | y | x |
a3 | z | y |
and I have to create a visualization like this one:
Initial Status | Difference |
x | (number of IDs with final status = x) - (number of IDs with initial status = x) |
y | (number of IDs with final status = y) - (number of IDs with initial status = y) |
z | (number of IDs with final status = z) - (number of IDs with initial status = z) |
How can I calculate the difference? Thank you in advance.
Fabio
Solved! Go to Solution.
You can create a measure like
Difference =
var currentStatus = SELECTEDVALUE( 'Table'[initial value])
var numFinalStatus = CALCULATE( COUNTROWS('Table'), REMOVEFILTERS('Table'[initial status]),
'Table'[final status] = currentStatus )
var numCurrentStatus = COUNTROWS('Table')
return numFinalStatus - numCurrentStatus
You can create a measure like
Difference =
var currentStatus = SELECTEDVALUE( 'Table'[initial value])
var numFinalStatus = CALCULATE( COUNTROWS('Table'), REMOVEFILTERS('Table'[initial status]),
'Table'[final status] = currentStatus )
var numCurrentStatus = COUNTROWS('Table')
return numFinalStatus - numCurrentStatus
Hi,
please check the below picture and the attached pbix file.
Difference measure: =
IF (
HASONEVALUE ( Data[Initial Status] ),
COUNTROWS (
FILTER ( ALL ( Data ), Data[Final Status] = MAX ( Data[Initial Status] ) )
)
- COUNTROWS (
FILTER ( ALL ( Data ), Data[Initial Status] = MAX ( Data[Initial Status] ) )
)
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
8 |