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
johnt75's avatar
johnt75
Super User
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