Calculated Measure not Summing

[ruesaint_denis]

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? 

[VahidDM]

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/

[ruesaint_denis]

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: 

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)))

[ruesaint_denis · Accepted solution]

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()))))