Forum Discussion
Total Label Value into variable - Stacked bar chart
- 5 years ago
Hi DonapatiSP_3105 ,
Can you share your .pbix file for test?
Remember to remove the confidential information.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
- 4 years ago
Hi DonapatiSP_3105 ,
Try:
% Amended = DIVIDE ( CALCULATE ( COUNT ( Total_Amended[RegistrationNumber] ), FILTER ( ALLSELECTED ( Total_Amended ), Total_Amended[New_Status] = MAX ( Total_Amended[New_Status] ) && Total_Amended[RegionName] = MAX ( Total_Amended[RegionName] ) ) ), CALCULATE ( COUNT ( Total_Amended[RegistrationNumber] ), FILTER ( ALLSELECTED ( Total_Amended ), [RegionName] = MAX ( [RegionName] ) ) ) )I made a simple sample for reference,you will see below in my example:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my areply as a solution!
Hey Pat,
Thanks for your response. Yes, calculate is not need in the numerator. I had removed filter which was applied and didnt remove calculate.
Yes, "New_Status" field is the right filter. I had renamed it for the visual. I had first tried with legend column in ALLSELECTED, i was getting 100% across.
Hi DonapatiSP_3105 ,
Can you share your .pbix file for test?
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!