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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi

        First of all thanks for your reply.

        I just did try the fomula and it didn't count blank but take the blank in the table.

        is there a way not to take the blank in first place?

        here is the the file.!

         

         

         

         

         

         

         

         

         

         

         

        thanks,