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

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,

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thank you so much.! this is exactly what i wanted.

        Can i please ask you one more question.?

         

        Please find the attached file.

        I want to analyse the plan vs actual progress by choosing many options which are in slicers.

         

        For example, choosing discipline piping > deck MDK > module P03 like that..

        Whenever i choose the slicer, the graph get incorrect.?

        I am pretty sure that it is possible, i have no clue.

         

        Basically i want to see the plan lines 0%-100% which slicers i choose with progressed line if there is progress.

         

        Thanks,!