Forum Discussion
greekjgg
2 years agoFrequent Visitor
Need to summarize column with parameters
What do I need to do so that the columns here show totals or accurate totals.....I think I need to add some sort of sum function in the Dax but not sure what that would look like. I have a custom sli...
- Anonymous2 years ago
Hi greekjgg
Try creating the following measure which references your current measure and use this new measure as a value in the matrix.
new measure = SUMX ( VALUES ( 'ALL IT 2'[Time Classification] ), [AVG PNT Month (Closed) Parameter TEST] )FYI: Obtaining accurate totals in DAX - SQLBI
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
greekjgg
2 years agoFrequent Visitor
NICE! This worked great!! Even adapting it for other calculations, thanks so much!!