topic Re: Calculated Measure not Summing in DAX Commands and Tips

Calculated Measure not Summing

ruesaint_denis — Fri, 28 Jan 2022 01:52:15 GMT

Hi everyone,

I have a calculated measure and for some reason it's not summing correctly. This is my measure, and below you can see the results:

Linqto Bucks Promotional Cost = Var true_24 = calculate(COUNTA(Orders[24 Rolling]), Orders[24 Rolling]=TRUE(), Orders[Payment Type]="Wire") return IF(true_24 = 2, 1000, IF(true_24=3, 2000, IF(true_24>3, 5000, 0)))

Orders[24 Rolling] is a Boolean True/False Column.

I am trying to see if there's X amount of Orders[24 Rolling] = True && Orders[Payment Type]="Wire" , then assign certain value.

You can see the sum isn't working at the end. Any ideas?

Re: Calculated Measure not Summing

VahidDM — Fri, 28 Jan 2022 02:06:40 GMT

Hi ruesaint_denis

Can you share a samole of your data table in a text format. BTW, check this link:

https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Calculated Measure not Summing

ruesaint_denis — Fri, 28 Jan 2022 15:31:05 GMT

Hi VahidDM ,

I am really not getting it. My data looks as the following:

User ID	Order ID	24hr Rolling	Payment Method
24	100	True	Uphold
30	105	False	Wire
45	200	True	Wire
45	204	True	Wire
24	101	True	Uphold
45	303	True	Wire

The desired output is the following:

- filter for orders where payment method = wire, and 24hr rolling = True, groupby user ID

- calculate promotional cost with different IF statements

if count of 2hr rolling = 2, then 1000

if count of 2hr rolling = 3, then 2000

if count of 2hr rolling > 3, then 5000

User ID	Sum of Count of 24hr Rolling where 24hr rolling = True	Promotional Cost
45	3	2000

I am able to calculate the appropriate promotional cost for each user ID, but the summing isn't working using this DAX measure:

Re: Calculated Measure not Summing

ruesaint_denis — Fri, 28 Jan 2022 16:27:16 GMT

This worked, I used this website to reach my solution:

https://finance-bi.com/blog/power-bi-totals-incorrect/

Linqto Bucks Promotional Cost = var summarizedTable = ADDCOLUMNS ( SUMMARIZE ( Orders, Orders[User Id]), "Qualifying Orders", CALCULATE ( COUNTA(Orders[24 Rolling]), Orders[24 Rolling]=TRUE(), Orders[Payment Type]="Wire")) return SUMX(summarizedTable, IF([Qualifying Orders]=2, 1000, IF([Qualifying Orders]=3, 2000, IF([Qualifying Orders]>3, 3000,BLANK()))))