Forum Discussion

AndyMeiks's avatar
AndyMeiks
Frequent Visitor
2 years ago
Solved

Card Showing Sum of Distinct Values

Hi team,   Hoping you can help with this - I've seen similar solutions for this but none that are quite perfect: I'm wanting to display a basic Card visual that summarises the unique values in a...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    2 years ago

    Hi AndyMeiks ,

     

    Try this:

    sum =
SUMX (
    SUMMARIZE ( 'Table', 'Table'[period_name], 'Table'[total_period_time] ),
    [total_period_time]
)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi AndyMeiks ,

 

Try this:

sum =
SUMX (
    SUMMARIZE ( 'Table', 'Table'[period_name], 'Table'[total_period_time] ),
    [total_period_time]
)

 

AndyMeiks's avatar
AndyMeiks
Frequent Visitor
2 years ago

Perfect, exactly what I wanted. Thankyou.