Forum Discussion
Helper IIIHelp with Dax formula for Matrix
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
Helper IIIIt comes up with an error for 'qry_Employees'[Division]. It says "Multiple arguments are not allowed in the ALLSELECTED function when the first argument is a table reference".
- themistoklis
Community Champion
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
Neither one works. The first gives an error and the second gives me the 20K total again.
- themistoklis
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