Forum Discussion

wesselvs's avatar
wesselvs
New Member
7 years ago

Create measurement filtered by date slicer

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

     

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    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.