Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Count If

Hi everyone. I'm want calculate like count if excel in power BI, but my sentence is not ok. I'm try create another measure, but this count all register for each operator.   MeasureCountIf = CALCU...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-cherch-msft

 

Thanks for your support, but not solve.

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
8 years ago

Anonymous

 

You may post what result you want or what trouble you meet.

 

Regards,

Cherie

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      8 years ago

      Hi Anonymous

       

      The table is simplified as below picture. Show you the measures:

       

      MeasureCountIf =

IF (

    SELECTEDVALUE ( 'Table'[Serial Number] ) <> BLANK (),

    COUNTROWS ( 'Table' ),

    0

)

      MeasureForTotal =
CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table'[Serial Number] ) )

       

       

      Regards,

      Cherie