Summarize DAX

[colourfullife]

Hi,

Need help.!

I want to summarize without coloums have no date.

anyone know how to do?

cheers,

Agnes

[v-danhe-msft]

Hi @colourfullife,

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

Regards,

Daniel He

[colourfullife]

Hi,

I want to take and count with only date.!

[v-danhe-msft]

Hi @colourfullife,

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

[colourfullife]

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 · Accepted solution]

Hi @colourfullife,

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

[colourfullife]

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]

Hi @colourfullife,

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

Regards,

Daniel He