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

You could try wrapping a CALCULATE around your SUM and AVERAGE. 

Also, check that the drivers by whom you are filtering have populated values for all the variables within your formulae, otherwise you will end up with blanks.