Forum Discussion

user900's avatar
user900
Helper II
2 years ago
Solved

Create Summy Table

I have a large data set with Date and Status. Status includes Assigned, In Progress and Complete.  I want to create a dynamic summary of the count of Complete and Total by Month.  The total will be t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi user900 

Thanks for the solution amitchandak  provided and I want to offer some more information for you to refer to.

Sample data

Create the following measures

Complete =
VAR a =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Status] = "Complete" )
RETURN
    IF ( a > 0, a, IF ( [Total] > 0, 0 ) )

Total = COUNTA('Table'[Status])
% = DIVIDE([Complete],[Total])

Then put the measures to a table visual.

Output

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.