Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a problem, in power bi, my control panel calculates the profit rate of the "sold project". The syntax that I am using is:
(Total project sales / Total projects delivered without sales) and the result is correct!
But I need an added filter of the date, when I add the filter, the profit rate is 100 always ... (the date is Total of projects delivered without selling). Please help 😞
WinRate OK
WinRate with filter
¡Por favor
Hi @Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.
Regards,
Frank
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |