Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Geeks,
I m trying to Filter a Measure(Sum of SALES) based on caluclation on Dimesnions GROUPID='PHL' AND ITEM='1003'
Basically, Needs the below SQL condition in DAX:
SUM(CASE WHEN NOT([GROUPID]='PHL' AND [ITEM]='1003') THEN SALES END)
Solved! Go to Solution.
Hi,
From what i understand, you wish to sum the sales after ignoring PHL from the GroupID column and 1003 from the Item column. If my understanding is correct, then try this
=CALCULATE(SUM(Data[Sales]),Data[GroupID]<>"PHL",Data[Item]<>1003)
Please note that i have assumed the Item column to be a numeric column. If not, then wrap 1003 in double quotes.
Hi,
From what i understand, you wish to sum the sales after ignoring PHL from the GroupID column and 1003 from the Item column. If my understanding is correct, then try this
=CALCULATE(SUM(Data[Sales]),Data[GroupID]<>"PHL",Data[Item]<>1003)
Please note that i have assumed the Item column to be a numeric column. If not, then wrap 1003 in double quotes.
In power BI if you are using DAX you need to use calculation calculate formula for example:
calculate formula take and expression and a filter
Excluded Dimension = calculate(sum(sales), [GROUPID]="PHL" and [item]=1003)
if you are creating a measure with dax you need to use double quotes and use calculation for example:
excluded Dimension = calculate(sum(sales),[groupID]="PHL" and [item]="1003")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |