Forum Discussion
DAX syntax
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
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