Forum Discussion
Summaries Table for Certain Values
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...
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") )
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.
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")
)Anonymous
By the way, you may help accept solution. Your contribution is highly appreciated.
