Forum Discussion

RoadeoAnalytics's avatar
RoadeoAnalytics
Advocate 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

RaocoSolutions's avatar
RaocoSolutions
Regular Visitor
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