Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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,PMS_FINANCIAL_PDS[Month Start],PMS_FINANCIAL_PDS[Index],PMS_FINANCIAL_PDS[ComplaintsPerMnth],PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]="Y")
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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")
    )

3 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-chuncz-msft
        Community Support
        7 years ago

        Anonymous 

         

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