Forum Discussion

lukaszj97's avatar
lukaszj97
Frequent Visitor
2 years ago
Solved

Calculate category average based on selected record

Hello,   I'm trying to find a way to utilize DAX to help us compare numerous project metrics against other projects with the same market sector categorization.   Example: Projects will have many...
Need Help
  • lukaszj97's avatar
    lukaszj97
    2 years ago

    I was able to solve this and have it display on cards as intended with the following measures:

     

    AvgLeadTimeSelectedProject =
    AVERAGE('Metric Table'[Lead Time])
     
    AvgLeadTimeSameMarketSector =
    CALCULATE(
        AVERAGE('Metric Table'[Lead Time]),
        ALL('Project Table'),
        'Project Table'[Market Sector] = SELECTEDVALUE('Project Table'[Market Sector]))
     
lukaszj97's avatar
lukaszj97
Frequent Visitor
2 years ago

I was able to solve this and have it display on cards as intended with the following measures:

 

AvgLeadTimeSelectedProject =
AVERAGE('Metric Table'[Lead Time])
 
AvgLeadTimeSameMarketSector =
CALCULATE(
    AVERAGE('Metric Table'[Lead Time]),
    ALL('Project Table'),
    'Project Table'[Market Sector] = SELECTEDVALUE('Project Table'[Market Sector]))