I need to create a measure (DirectQuery mode) in order to calculate the number of rows that have the same values for the field [OriginType] excluding the ones that comes from the same parents. Following an example:
Parents
Details
My representation would be:
So, I need to exclude in the calculation for each parents, the details who had the same parents. How can achieve that using PowerBI Dax?
MyMeasure :=
VAR ThisParent =
MIN( Table1[Parent] )
RETURN
COUNTROWS( FILTER( ALL( Table1 ), Table1[Parent] <> ThisParent ) )