Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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
@praphull , You can try like
calculate(sumx(Values(Table[Column2]), calculate(distinctcount(Table[ID])) )
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.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |