Forum Discussion

rbartlejr's avatar
rbartlejr
Icon for Helper III rankHelper III
5 years ago
Solved

Help 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...
Need Help
themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
5 years ago

rbartlejr 

 

Try either this: 

ActCnt =
CALCULATE (
SUM('qry_Employees'[SumOfValue]),
FILTER (
ALLSELECTED('qry_Employees'[Date], 'qry_Employees'[Division]),
'qry_Employees'[Metric_Code] IN { "ActCnt" }
)
)

 

Or this

 

ActCnt =
CALCULATE (
SUM('qry_Employees'[SumOfValue]),
FILTER (
ALLSELECTED('qry_Employees'),
'qry_Employees'[Metric_Code] IN { "ActCnt" }
)
)

rbartlejr's avatar
rbartlejr
Icon for Helper III rankHelper III
5 years ago

Neither one works. The first gives an error and the second gives me the 20K total again.

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    best if you send a sample file to us... mask any sensitive data..

    also it would be great if you provide the correct output on a table

    • rbartlejr's avatar
      rbartlejr
      Icon for Helper III rankHelper III
      5 years ago

      There is a link to the data in the original post. It has the Access database with all of the tables and queries. No sensitive information is included. As for what I'd like to see it would look like this:

                                  Date             Date            ............

                                  3/14/2020   3/21/2020

      Division ESD         157             157               ............

                    FMS        227             227             ............