Forum Discussion

powerbirino's avatar
powerbirino
Frequent Visitor
9 years ago
Solved

DAX SAMEPERIODLASTYEAR + Filter?

Currently I'm using this DAX formula on a Card and it's working:   CALCULATE( DISTINCTCOUNT(Sales[DocumentNumber]); FILTER(Sales; Sales[Field1] = "1" && Sales[Field2] = VALUE(1)) ) But, I want t...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    powerbirino

     

    Please update the formula as below and try again.

     

    Measure =
    CALCULATE (
        DISTINCTCOUNT ( Sales[DocumentNumber] );
        FILTER ( ALL ( Sales ); Sales[Field1] = "1" && Sales[Field2] = VALUE ( 1 ) );
        SAMEPERIODLASTYEAR ( Dates[Date] )
    )

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

powerbirino

 

Please update the formula as below and try again.

 

Measure =
    CALCULATE (
        DISTINCTCOUNT ( Sales[DocumentNumber] );
        FILTER ( ALL ( Sales ); Sales[Field1] = "1" && Sales[Field2] = VALUE ( 1 ) );
        SAMEPERIODLASTYEAR ( Dates[Date] )
    )

 

Best Regards,

Herbert

powerbirino's avatar
powerbirino
Frequent Visitor
9 years ago

It was that!

 

Thank you!!