powerbidaxformulapowerbi-desktopdirectquery

MS PowerBI - Excluding certains rows


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?


Solution

  • MyMeasure :=
    VAR ThisParent =
        MIN( Table1[Parent] )
    RETURN
        COUNTROWS( FILTER( ALL( Table1 ), Table1[Parent] <> ThisParent ) )