Forum Discussion

RoadeoAnalytics's avatar
RoadeoAnalytics
Icon for Advocate I rankAdvocate I
3 years ago
Solved

Power BI DAX Calculation

Hi,   I would like some help figuring out how to derive at revenue per driver for the attached dataset. I've gotten this to work on a high level, but when it's filtered by driver, it returns blank....
Need Help
  • RaocoSolutions's avatar
    RaocoSolutions
    3 years ago

    RevenueDriverPU =
    VAR _avgPU = Calculate(AVERAGE('All P&D Tables'[Rate$/PU #PKG]),ALL('All P&D Tables'[DRIVER NAME]))
    return
    SUM('All P&D Tables'[PU #PKG AI]) * _avgPU

AndrewPF's avatar
AndrewPF
Icon for Helper V rankHelper V
3 years ago

I think you need to revisit the merging of your tables. 

If the Rate$ is 0, whatever else you do, the result will be 0. 

  • RoadeoAnalytics's avatar
    RoadeoAnalytics
    Icon for Advocate I rankAdvocate I
    3 years ago

    Is there no way to use the rate from one table and multiply it by values in another table?

    So if the rate comes from PKG Summary table, let's say it's $0.43. Can we not populate this value in Additional Information table? Maybe add a column that populates these rates? The calculations would need to be done on a Settlement Date level. Meaning that for each settlement date it would need to run the calculation. Please let me know if you might have any other ideas to solve this. Appreciate your time and help.