Forum Discussion

siquilesq's avatar
siquilesq
Frequent Visitor
3 years ago

Total by Category

Hi Everyone:

 

I need I little help with that: I want to calculate the Total of each Unit to put in bar chart.

 

 

 

Need Help

3 Replies

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi siquilesq  try it

    Total = 
IF( HASONEVALUE(Dates[Year]),
[measure],
SUMX( VALUES('Dates'[Year]),
[measure]))
  • siquilesq's avatar
    siquilesq
    Frequent Visitor
    3 years ago

    Thanks DimaMD , but the final result I expected is: where red one is the total of each units.