Summaries Table for Certain Values

[Anonymous]

Hi Experts

i am trying to summaries my master table to a smaller subset, based on  PMS_Financial_PDS[Roll12_Complete_PDS_IND]="Y". cannot get the DAX correct.

Table = SUMMARIZE(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[Month Start],PMS_FINANCIAL_PDS[Index],PMS_FINANCIAL_PDS[ComplaintsPerMnth],PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]="Y")

[MattAllington]

I very much doubt you need to do this. What are you trying to achieve?  The visuals in Power BI are what you should be using to create the table structure, and a measure to build the aggregates. 

[Anonymous · Accepted solution]

Agree Matt...thats what i am trying to do..

i have managed to work it out i believe.

SUMMARIZECOLUMNS(PMS_FINANCIAL_PDS[Month Start],PMS_FINANCIAL_PDS[Index],PMS_FINANCIAL_PDS[ComplaintsPerMnth],FILTER(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]="Y")
    )

[v-chuncz-msft]

@Anonymous 

By the way, you may help accept solution. Your contribution is highly appreciated.