Forum Discussion

deigos's avatar
deigos
New Member
3 years ago

Could someone help me with totalizer?

Well, I'm solving a problem in power bi that I've never seen before, I have columns of gas stations, and the amount of liters fueled are calculated from two different tables that I call the name of the gas station So the two columns will not always have values, but if they do, adding the two columns will give the total However, the total is incorrect, and it is only incorrect when it has values ​​from the other column Attachment for more detail:

 

I need to multiply the third column by the fourth, and thus hava the fifth result, it is correct, but the totalizer is incorrect
Result correct: 127049,41

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
    I have columns of gas stations, and the amount of liters fueled are calculated from two different tables

     

    Please provide sanitized sample data that fully covers your issue. Please provide the data in usable format, not as a screenshot.
    Please show the expected outcome based on the sample data you provided.

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi deigos ,

     

    Are the third column and the fourth column measures? When a Measure is used on rows in a table, the column total for those rows is not calculated based on a sum of the results in the rows, but instead it calculates using the same Measure formula and applies it to the total of the data selected.

    You can try to create another measure to correct the result as below:

    Fifth Column Correct = 
IF(COUNTROWS(VALUES([Project No]))=1,[fifth column],SUMX(VALUES([Project No]),[fifth column])

    If the above one can't help you get the desired result, please provide your sample data or pbix file without privacy information.

     

    Best Regards,
    Community Support Team _ xiaosun

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