Forum Discussion
Calculated Measure not Summing
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()))))
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/
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)))
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()))))