count of id with respect to other column

[praphull]

Hi, 
My case is of unvipot column of many column.
If we choose single select value then it counts expected results, but we choose 'All" then result is lesser than expected due to distinct count. 
Here I am not able to use count function because of 2-3 times unpivot used with other column. 
Kindly help to fix it. 

[v-stephen-msft]

Hi @praphull ,

Please provide some sample data and expected results. Note: Protect your private data.

Best Regards,

Stephen Tao

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

[praphull · Accepted solution]

Hi @v-stephen-msft ,
I got solution by some other way.
Thanks for reply.

[v-stephen-msft]

Hi @praphull ,

Thanks for your response and glad to hear that your issue was resolved.

If you can, please share your solution, more people will benefit.😊

Best Regards,

Stephen Tao

[amitchandak]

@praphull , You can try like

calculate(sumx(Values(Table[Column2]), calculate(distinctcount(Table[ID])) )

[praphull]

Hi @amitchandak 
No, It also gives same result as simple distinctcount.
Not getting expected result.
I need sum of count of all individuals when selected All.