Percentage of selected row

[Ade1991]

Hi

What is the formula to know the dynamic percentage of selected row in a table ?

Imagine I have a table with 10 rows.

When i don't select anything, my measure is 100%.

When I select something (concerning for exemple 2 rows), I want to have 20% as result measure.

I'm trying with Countrow/CountA but it is not dynamic, and always display 100 %.

Thanks,

Alex

Thanks by advance,

Alex

[v-xicai]

Hi  @Ade1991 ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Ade1991 ,

You can try to create measure like DAX below.

Measure1= DIVIDE(COUNTROWS(ALLSELECTED(table1)),COUNTROWS(ALL(table1)))

Best Regards,

Amy

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