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

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,!

     

     

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

      Hi Anonymous,

      It's pleasant that your problem could be solved and I suggest you recreate a topic for your new problem.

       

      Regards,

      Daniel He