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

AndrewPF's avatar
AndrewPF
Helper V
3 years ago

I've had a quick look at your file and, for me, the PU #PKG / PU #STOPS chart in the Driver Performance tile does update when I select a driver.  It goes blank if there is no data for a particular driver (e.g. Alf) but it's populated for one who does have data (e.g. Amadi). 

RoadeoAnalytics's avatar
RoadeoAnalytics
Advocate I
3 years ago

Hi Andrew, thankyou for taking a look. Could you please let me know how you did that? If you would be able to send me the file back and let me know the changes made, that would be greatly appreciated.

I cannot replicate on my side. Just tried for Amadi and it turns up blank where there are 4 packages that should be paid for. Please see screenshot below.