Forum Discussion
Helper IProblems implementing conditional formatting on bar chart with grand total count measures
Hi andrea100 ,
Use the ALL function to wrap the parameter table in COUNTROWS.
In this way, the COUNTROWS function is not filtered by the visual rows field and thus returns all rows of the table.
Below% = [Count BelowAverage]/COUNTROWS(ALL('Table'))*100
The final result is as follows and hope it will meets your needs.
Please see the attached pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
andrea100Hi, thank you for looking into this. I tried, but it gives me the output 0.00% when I use ALL
Hi andrea100 ,
Can you provide the sample PBIX file? We can understand and help you better.How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.