Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report that show if my commercial team performed their sales correctly
On the bottom half of the report page, there is a table showing the list of the sales that has not been performed correctly
The report is made to be exported in PDF through power automate (then emailed) so If there is too many line of the table I want it to show a message on the table like "Above 25 sales performed incorrectly, please go to the power BI report to check the list".
Any idea on how I can make it so, if the number of "incorrect sales" is above 25 (I already have a measure that count incorrect sales), the content of the table is replaced by a message ?
Solved! Go to Solution.
Hi @Arkhos94 ,
This might work but it's a tricky one.
1. Your measure to count the number of rows should be something like this:
This won't necessarily replace the table but add a message overlayed on top of it.
Hi @Arkhos94 ,
This might work but it's a tricky one.
1. Your measure to count the number of rows should be something like this:
This won't necessarily replace the table but add a message overlayed on top of it.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |