Forum Discussion

FabioC86's avatar
FabioC86
New Member
4 years ago
Solved

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 Statu...
DAX
Difference
status change
  • johnt75's avatar
    johnt75
    4 years ago

    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
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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