Create measurement filtered by date slicer

[wesselvs]

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

[Ashish_Mathur]

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.

[v-diye-msft]

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.

[Anonymous]

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])