Forum Discussion

Giada90's avatar
Giada90
Helper IV
3 years ago
Solved

problems with total

Hi, I have this formulas: Ricavi_ACT = CALCULATE(     SUM('Aggregato'[Ricavi])*-1,     'Aggregato'[Trascodifica] IN { "consuntivo" } )   Costi fornitura_ACT = CALCULATE(     SUM('Aggre...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Giada90 ,

     

    According to your statement, I think your issue should be caused by IF function in your code. Based on the logic of IF function, when [Ricavi_ACT] in total <>0, your total will return [Ricavi_ACT]-[Costi fornitura_ACT] (strange numbers) and when [Ricavi_ACT] in total equal to 0, your total will return 0.

    As far as I know, you can sum this measure by the column in X aixs. So if you add [Month] in visual X aixs, you can try below code.

    Measure = 
SUMX(VALUES('TableName'[Month]),[Primo_Margine_ACT])

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Giada90 ,

 

According to your statement, I think your issue should be caused by IF function in your code. Based on the logic of IF function, when [Ricavi_ACT] in total <>0, your total will return [Ricavi_ACT]-[Costi fornitura_ACT] (strange numbers) and when [Ricavi_ACT] in total equal to 0, your total will return 0.

As far as I know, you can sum this measure by the column in X aixs. So if you add [Month] in visual X aixs, you can try below code.

Measure = 
SUMX(VALUES('TableName'[Month]),[Primo_Margine_ACT])

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Giada90's avatar
Giada90
Helper IV
3 years ago

thanks!!