Forum Discussion
Help with Measure behavior in Power BI Report Builder
Measure created using data from multiple tables in Power BI giving us undesirable results in Report Builder Render.
Rate per Hour = (Revenue - Expenses) / Hours
Each part of that equation comes from a different table in the dataset. The whole dataset is indeed connected to the RDL.
The measure works well at the client level because all of those are assigned to clients, however when we ask the service to reach further to roll it to the DIRECTOR level (every client is assigned a director), it is not computing it the way Power BI Desktop does.
It averages all client rate per hours for that director instead of doing what we would prefer: (sum of revenue for the directors clients - sum of expenses for the directors clients) / sum of hours for that directors clients.
Any ideas?
1 Reply
Small update. I have it working on the basic level by changing this property to Output instead of Auto Yay! However, when totaling or putting the measure in a parent group, it still manfunctions. Anyone know what to do there?
