Forum Discussion
DAX syntax
Hi,
I'm trying to SUM a few variables, but I'm not sure how to write this in DAX.
Please take a look at my attached screenshots and you'll see what I am trying to do. The screenshot with the question mark is my attempt at it, but it doesn't work. Any pointers are appreciated, thank-you
this worksthis does not work
With this sample table called 'fTable'
Try:
Sum A | C | D = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] IN {"A", "C", "D"}))which delivers the same result as:
Sum A + C + D = VAR _A = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] = "A")) VAR _C = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] = "C")) VAR _D = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] = "D")) RETURN _A + _C + _D
4 Replies
Are you trying to filter the table where the value meets all 3 conditions (so AND) or if the value meets one of the conditions (so OR)?
yes, I want all 3 conditions (variables) included - AND. I want all 3 summed up. Each variable has a numerical value, so if it's 3 + 4 + 9, then I want to see 16 total in the frontend.
In my other BI tool (Qlik Sense), the following syntax is used (& it works):
Sum({<[Activity]={'33-McDonalds_UK-thankyou - Appli_Submision','McDon_IE_ATS_ThankYou_Pg'}>}[Total Conversions])
this also works:
Sum({<[Activity]={'Submitted_Application'}>}[Total Conversions])
+
Sum({<[Activity]={'UK_ATS_Submitted_Application'}>}[Total Conversions])
+
Sum({<[Activity]={'AU_ATS_Submitted_Application'}>}[Total Conversions])but I can't find the correct way to write this in PowerBI DAX
With this sample table called 'fTable'
Try:
Sum A | C | D = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] IN {"A", "C", "D"}))which delivers the same result as:
Sum A + C + D = VAR _A = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] = "A")) VAR _C = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] = "C")) VAR _D = CALCULATE([Sum Value], FILTER(fTable, fTable[Category] = "D")) RETURN _A + _C + _D