Forum Discussion

PZU_DGW's avatar
PZU_DGW
Regular Visitor
5 years ago
Solved

Filtering table

As a beginner in DAX I have this report that can be filtered on a specific year and some other filters. But I want to calculate a measure that is a snapshot, not depending on a specific year or other...
Help
  • PZU_DGW's avatar
    PZU_DGW
    5 years ago

    Thanks Jos!

     

    That's the solution I was looking for! I forgot to add the '

    ALL(PAYMSCHEMETABLE),'. It did the trick.
     
    Greetings PZU
Jos_Woolley's avatar
Jos_Woolley
Solution Sage
5 years ago

Hi,

MeasureALL =
CALCULATE (
    COUNTROWS ( PAYMSCHEMETABLE ),
    ALL ( PAYMSCHEMETABLE ),
    PAYMSCHEMETABLE[SCHEMSTATUS] = 0,
    CONTRACTS[ContractStatus] <> "Ended"
)

Regards

PZU_DGW's avatar
PZU_DGW
Regular Visitor
5 years ago

Thanks Jos!

 

That's the solution I was looking for! I forgot to add the '

ALL(PAYMSCHEMETABLE),'. It did the trick.
 
Greetings PZU
  • Jos_Woolley's avatar
    Jos_Woolley
    Solution Sage
    5 years ago

    You're welcome!

     

    Cheers