Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I recently started creating some dashboards with PowerBI.
Im trying to calculate the price per hour in a measurement which takes the sum of the income per customer from table a and divide this from table b
SUM(mutations[Positief])/SUM(Timecaptured[hours])
However when i change the date slicer the data does not change and gives us corrupt calculations.
Can this be solved somehow? What am i doing wrong?
Regards,
Wessel
Hi,
Assuming Mutations and Timecaptured tables have a Date column, create a Calendar Table and build a relationship from the Date column of both Tables to the Date column of the Calendar Table. Build your slicer from the Date column of the Calendar Table.
Hi @wesselvs
If you've fixed the issue by your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. thanks!
If not, please provide more details about your question.
Hi,
Can you show us some sample of this Data. If you have the Customer Column in to the Table,
SUM(TableA[Value])/ CALCULATE(SUM(TableA[Value],TREATAS(VALUES(TableA[Customer]),TableB[Customer])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |