Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to find percent in clustered bar chart by axis/legend...any idea?? i have show in matrix..i want that to be in clustered chart!!any idea???
Solved! Go to Solution.
Hi @Gokul,
I would suggest you use a measure instead.
Measure = DIVIDE ( COUNT ( Table1[id] ), CALCULATE ( COUNT ( Table1[id] ), ALLEXCEPT ( Table1, Table1[dept] ) ), 99999 )
Best Regards,
Dale
Hi @Gokul,
I would suggest you use a measure instead.
Measure = DIVIDE ( COUNT ( Table1[id] ), CALCULATE ( COUNT ( Table1[id] ), ALLEXCEPT ( Table1, Table1[dept] ) ), 99999 )
Best Regards,
Dale
Will this work if the all except argument is from another table in the model? Thanks!
what does 9999 denotes??
Hi @Gokul,
That's the alternative value in case of the failure of the calculation. You will know something is wrong when you get 99999. You can change it or ignore it like below.
Measure = DIVIDE ( COUNT ( Table1[id] ), CALCULATE ( COUNT ( Table1[id] ), ALLEXCEPT ( Table1, Table1[dept] ) ) )
Best Regards,
Dale