Forum Discussion

joao_maia_ext's avatar
joao_maia_ext
Frequent Visitor
5 years ago
Solved

Total not Correct

Hello Freinds,   I've being struggling with a relative simple and recurrent problem I believe.. I Have a set of measures and results inside the table are ok, although the total is not correct.   ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  joao_maia_ext ,

    You can use HASONEVALUE to resolve incorrect totals.

    Here are the steps you can follow：

    1. According to your description, I created sample data.

    2. First, suppose you have a measure and find that the sum calculated by this metric is incorrect.

    Measure_Sum =
IF(SUM('Table'[Amount])<1000,0,SUM('Table'[Amount]))

    3. Then to calculate the sum, you can create a measure.

    Calculate Sum =
var Table1=SUMMARIZE('Table','Table'[Date],"_value",[Measure_Sum])
return IF(HASONEVALUE('Table'[Date]),[Measure_Sum],SUMX(Table1,[_value]))

    4. Result.

     

    Best Regards,

    Liu Yang

    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
5 years ago

Hi  joao_maia_ext ,

You can use HASONEVALUE to resolve incorrect totals.

Here are the steps you can follow：

1. According to your description, I created sample data.

2. First, suppose you have a measure and find that the sum calculated by this metric is incorrect.

Measure_Sum =
IF(SUM('Table'[Amount])<1000,0,SUM('Table'[Amount]))

3. Then to calculate the sum, you can create a measure.

Calculate Sum =
var Table1=SUMMARIZE('Table','Table'[Date],"_value",[Measure_Sum])
return IF(HASONEVALUE('Table'[Date]),[Measure_Sum],SUMX(Table1,[_value]))

4. Result.

 

Best Regards,

Liu Yang

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