Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
HI PowBI,
I created a custom measure using the 2 formulas below:
Solved! Go to Solution.
Hi @romovaro ,
According to your descriptin, it seems that you want to show 27 rows based on some filters.
I have built a data sample, please tell me your expected output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Drag the current workload measure (which returns number 27) to the visual as well.
Hi @romovaro ,
According to your descriptin, it seems that you want to show 27 rows based on some filters.
I have built a data sample, please tell me your expected output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Evelyn
thanks. It works. I can show the resuls i need (due to current data...now is 24).
I have been asked to show a "time table" month or week with current workload by owner. THe problem i have with this one is that sometimes it shows negative results....and that's not possible. Or you have current workload during the months or zero...but not negative...any fix? thanks
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |