Forum Discussion

mp390988's avatar
mp390988
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

calculate with summarize vs values

Hi,   I have created the below measure which is just a very expanded way of achviening the same result by using keepfilters but i am doing this for my own understading.   Contoso and Red only v3...
Need Help
  • mp390988's avatar
    mp390988
    1 year ago

    Hi,

     

    Yes I have had to opportunity to look at the information provided by Deku and Ashish_Mathur .
    I find Deku suggestion helpful and I have taken on their suggestion and responded back on this thread, now I am awaiting for a repsonse to help me further.

     

    Thank You

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

You should be able to simplify your measure to:

Contoso and Red only v3 = CALCULATE(SUM(Sales[Sales Amount]),'Product'[Brand] = "Contoso",'Product'[Color] = "Red")