Forum Discussion

sandeepk66's avatar
sandeepk66
Advocate I
8 years ago
Solved

Exclude Dimension for a Measure

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([GR...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

emadrigal's avatar
emadrigal
Helper II
8 years ago

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)