Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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")
Solved! Go to 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") )
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.
User | Count |
---|---|
84 | |
81 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |