Forum Discussion

greekjgg's avatar
greekjgg
Frequent Visitor
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 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!