Forum Discussion
rbartlejr
Helper III
Helper IIIHelp with Dax formula for Matrix
I'm having an issue with a DAX formula. I've tried using the FILTER function but I just can't get it correct (I'm still very novice with DAX). I have a database in Acess that comes from an Excel repo...
Could you please have a look at the following link and let me know if this is what you would like to see?
https://www.dropbox.com/s/lovggqivwownchj/PowerBI_data.pbix?dl=0
themistoklis
Community Champion
Community Champion
Can you try the following formula:
ActCnt =
CALCULATE (
SUM('qry_Employees'[SumOfValue]),
FILTER (
ALLEXCEPT('qry_Employees', 'qry_Employees'[Date]),
'qry_Employees'[Metric_Code] IN { "ActCnt" }
)
)