TOTAL CALCULATION IS WRONG

[a-tlantis]

I have one table that consist of  these columns

receptionNo        tableType      Price 

     1023                cash              100

     1022                ny                  210

    1020                cash              500

   1019                 ny                 50

   1018                 cash             70

==========================

i have this table  i want to have total  price just for rows that  the column tabletype is "Cash"  and it should be 670

but it show the wrong number            

[Anonymous · Accepted solution]

Hi @a-tlantis ,

Based on the description, try using the following DAX formula to create a new measure.

TotalCashPrice = CALCULATE(SUM('Table'[Price]), 'Table'[Type] = "cash")

Drag the measure to the card visual.

Best Regards,

Wisdom Wu

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

[Greg_Deckler]

@a-tlantis First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8