Add column that count summarized variable

[Anonymous]

I am trying to summarize some data that is set out as follows

I wannt to show the number of tasks for each person and also what the worst [Due Status] is for each person. So for example Person A has 4 tasks and the worst [Due Status] is 'Overdue'. I have done this by adding a calculated column [Rank] and then creating a new table using the following DAX 

Summary = 
ADDCOLUMNS(
    SUMMARIZE(
        'Table1',
        Table1[Person],
        "Number of tasks", CALCULATE(COUNTROWS('Table1'))
    ),
    "Status",
        CALCULATE (
            SELECTCOLUMNS (
                TOPN ( 1, 'Table1', 'Table1'[Rank] ),
                "val", 'Table1'[Due Status]
            )
        )
)

There is one extra bit I am stuggling with. That is also adding a column that counts the number of times the worst [Due Status] appears.

For example:

• For Person A it would be 'Overdue' and count would be 2.
• For Person B it would be 'In date' and the count would be 4.
• For Person E it would be 'Due Soon' and the count would be 1. 

[Ashish_Mathur]

What is th definitition of "worst due status"?

[mangaus1111 · Accepted solution]

Hi @Anonymous ,

if you create additional calculated column and/or calculated table, your model becomes slow performing.

See my pbi file. I have used a small snapshot table for the ranking.

https://1drv.ms/u/s!Aj45jbu0mDVJi2GypBfgxC2_wMkd?e=Ca9qyB

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

[lbendlin]

please provide the sample data in usable format, not as a screenshot.