Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarize DAX

Hi,

 

Need help.!

 

I want to summarize without coloums have no date.

anyone know how to do?

 

cheers,

Agnes

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could refer below formula:

    Finish Actual_Over = SUMMARIZE(CALCULATETABLE('Dp List','DP List'[Finish Actual]<>BLANK()), 'DP List' [finish Actual], "DP List Finish Actual#", COUNT('DP List'[D/P&BOM]))

    Result:

    Hope it could help you.

     

    Regards,

    Daniel He

7 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    What is your desired result, could you please post your desired result if possible?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      I want to take and count with only date.!

      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

        You could try to ues below formula to filter the data without blank:

        Finish Actual_Over = SUMMARIZE('Dp List', 'DP List' [finish Actual], "DP List Finish Actual#", CALCULATE(COUNT('DP List'[D/P&BOM]), FILTER('DP List', 'DP List' [finish Actual]<>BLANK())))

        If it still could work for you, could you please share your pbix file to hava a test if possible?

         

        Regards,

        Daniel He