How to measure value can count group by

[sprao]

Hi,

Under One group we have multiple projects, each project have different status  we need to consider if have one project High risk then entire group we can consider High Risk.

But in dashboard graph we need to show How many projects are diffrent status.

 How to count above meassure value with correct count..

[v-janeyg-msft · Accepted solution]

Hi, @sprao 

Your needs are achievable, You can use summarize() to create the context then count them.

Like this:

measure =
COUNTX (
    SUMMARIZE ( ALL ( table ), [Group Tax], "29.Risk", MAX ( table[column] ) + 0 ),
    [29.Risk]
)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[Aburar_123]

Hi @sprao ,

It will be helpful if you can provide some sample data.