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.
I've a table Fact Performance Indicators
salesorderid | Activity_Inter_Id | date | amount | customer | Coex |
111 | 20 | 03/06/2022 | 200 | JJJ | 0,3 |
22 | 60 | 03/07/2022 | 900 | HHHH | 0,4 |
33 | 40 | 03/06/2022 | 1200 | JJJHH | 0,7 |
34 | 20 | 03/06/2022 | 7200 | JJJJJ | 0,3 |
For the same year and activity_inter_id, I've the same value for Coex
Here's the data model
In the report, I've two calendars and I've two measures
The results are wrong: the coex is a value between 0 and 1 and it should not be count or summarize, here the results for calendar 2 are too much and more than 1
Coex is a semi additaive value
Hi @Anonymous ,
What's the expected result for [CoEx calendar 1] and [CoEx Calendar 2]? Could you please explain their backend calcuation logic with some sample data and special examples? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards