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.

Anonymous's avatar
Anonymous
Not applicable
8 months ago

Hi jeeva-chandru ,

If you must aggregate at Quarter/Vertical/Subvertical/GBE/Region level. Try the below measure.

 

 

M-AOPTarget =

VAR SummaryTable =

    SUMMARIZE(

        AOP_EDW_MERGED,

        AOP_EDW_MERGED[VERTICAL],

        AOP_EDW_MERGED[SUB VERTICAL],

        AOP_EDW_MERGED[GBE],

        AOP_EDW_MERGED[REGION],

        AOP_EDW_MERGED[QUARTER],

        "OrderAmount", SUM(AOP_EDW_MERGED[Orders ($M)])

    )

RETURN

CALCULATE(

    SUMX(SummaryTable, [OrderAmount]),

    AOP_EDW_MERGED[VERTICAL] <> "5 - Life Sciences",

    REMOVEFILTERS(AOP_EDW_MERGED[SN

APSHOT_DATE])

)

 

 

If my response as resolved your issue please mark it as solution and give kudos.