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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.