Count If

[andreluizrenda]

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 =
CALCULATE (
COUNTROWS ( Table );
FILTER ( Table; Table[Operator] = Table[Operator] );
FILTER ( Table; Table[Serial Number] = Table[Serial Number] )
)

Thanks for help.

 

[v-cherch-msft]

@andreluizrenda

To get the table as requested, you may try 2 ways:
1. Create a measure:

Measure :=
CALCULATE(COUNTROWS('Table'))

2. Create a column:

Column =
COUNTX (
    FILTER ( 'Table', 'Table'[Serial Number] = EARLIER ( 'Table'[Serial Number] ) ),
    'Table'[Serial Number]
)

Regards,
Cherie

[andreluizrenda]

@v-cherch-msft

Thanks for your support, but not solve.

[v-cherch-msft]

@andreluizrenda

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

Regards,

Cherie

[andreluizrenda]

Hi Cherie, i have a excel to calculate like this. I need calculate the same in power bi.

When i try your solution, the result is same like total, if i sum repetitions must be more total.

I share my archive to expland more.

https://drive.google.com/file/d/1Z1exWNaiMJWi5PwbCZybNNI27VhuuGbm/view?usp=sharing

[v-cherch-msft]

Hi @andreluizrenda

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

[andreluizrenda]

Anyone could help me