Forum Discussion

Santy241's avatar
Santy241
Frequent Visitor
1 year ago
Solved

Average in Power Bi Matrix

Hi everyone! 👋 I’m new to Power BI and I need your help using matrix visuals   I’m trying to recreate the structure of the following Excel summary in Power BI, using a matrix visual. The actual va...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi Santy241 ,

     

    Depending on how you have the tables setup I would create a measure with the following code:

    IF(ISINSCOPE(Table[Calendar], [Productivity H], AVERAGEX(VALUES(Table[Technology]), [Productivity H])

     

    Be aware that without any data is difficult to give you a better formula.

MFelix's avatar
MFelix
Super User
1 year ago

Hi Santy241 ,

 

Depending on how you have the tables setup I would create a measure with the following code:

IF(ISINSCOPE(Table[Calendar], [Productivity H], AVERAGEX(VALUES(Table[Technology]), [Productivity H])

 

Be aware that without any data is difficult to give you a better formula.