Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Filter Ignoring in Table visual

Hi Guys,       My current measure =  USOnlineLevel1 = CALCULATE(                                                 Sales[Sales Amount],                                                 Sales[Sal...
Need Help
Show and Tell
Tips and Tricks
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    If you write a formula like that, the context of Customer[Education] is overridden. So all the rows have values now. Please try a formula like below. 

     

    USOnlineLevel1 =
CALCULATE (
    Sales[Sales Amount],
    Sales[SalesStore] = "Contoso North America Online Store",
    FILTER (
        Customer,
        Customer[Education] = "Bachelors"
            || Customer[Education] = "Graduate Degree"
    )
)

     

    Best Regards,
    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

     

    Best Regards,

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Share the link from where i can download your PBI file.