Replicate this COUNTIFS with DAX

[rolo]

Hello,

I have Excel COUNTIFS formulas, but I was not able to reproduce them using DAX functions

I would appreciate your valuable help!

You can download example here: easyupload.io

 

[Chihiro]

First create LastPeriod measure.

=CALCULATE(MAX([YEARMONTH]),FILTER(Tabla1,[TYPE]="ACTUAL"))

Then add HC BUDGET.

=
VAR LP = [LastPeriod]
RETURN
    CALCULATE (
        COUNTROWS ( Tabla1 ),
        FILTER ( Tabla1, [YEARMONTH] = LP && [TYPE] = "BUDGET" )
    )

Then just change condition for HC ACTUAL.

Add all 3 as values field to Pivot Table.

 

[rolo]

Thanks Chihiro, it worked perfect!