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

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. 

RoadeoAnalytics's avatar
RoadeoAnalytics
Advocate I
3 years ago

Thank you, Andrew, for your reply. I tried wrapping CALCULATE but it made no difference.

 

I have merged queries into one table. And yes, the Drivers would be a field that's from a different table and was merged into one big table called All P&D Tables. I think the formula needs to point to these rows where the data is. I've included a link to the pbix file in my original post. Any chance you can take a look?