Forum Discussion

jeeva-chandru's avatar
jeeva-chandru
New Member
8 months ago
Solved

Issue with Aggregation and Filtering

Hello,   I have a DAX formula in Power BI that I need help with. I've merged the AOP and Sales datasets into a combined dataset called AOP_EDW_Merged. This dataset includes columns such as Opportun...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    8 months ago

    jeeva-chandru 

     

    Please share a simplified version of your PBIX file (in English) without sensitive data. You can upload it to a public cloud service like OneDrive, Google Drive, or Dropbox and share the link. This will help in understanding your data structure and the issue, allowing for more precise guidance.

Kedar_Pande's avatar
Kedar_Pande
Super User
8 months ago

  

M-AOPTarget =
CALCULATE(
SUM(AOP_EDW_MERGED[Orders ($M)]),
AOP_EDW_MERGED[VERTICAL] <> "5 - Life Sciences",
REMOVEFILTERS(AOP_EDW_MERGED[SNAPSHOT_DATE])
)

 

Test this - should respond to all slicers correctly.


If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

jeeva-chandru