cancel
Showing results for
Did you mean:
New Member

## Calculate difference in statuses

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

1 ACCEPTED SOLUTION
Super User

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``````
2 REPLIES 2
Super User

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``````
Super User

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] ) )
)
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

#### Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors