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

When I open the downloaded version, I can't see the visual you've highlighted, nor can I see any measure or column called RevenueDriverPU.  When I select the driver Amadi, I see this: