How to compare two values from different perspectives?

You would be looking at a monster like this

UNION(
SELECTCOLUMNS(SUMMARIZECOLUMNS('Calendar'[year week], 'Fact'[Manager], "Average", 'Fact'[Average]),"Week",[year week],"Average",[Average],"Attribute","Manager","Value",[Manager]),
SELECTCOLUMNS(SUMMARIZECOLUMNS('Calendar'[year week], 'Table_1'[Platform], "Average", 'Fact'[Average]),"Week",[year week],"Average",[Average],"Attribute","Platform","Value",[Platform]),
SELECTCOLUMNS(SUMMARIZECOLUMNS('Calendar'[year week], 'Table_1'[Unit], "Average", 'Fact'[Average]),"Week",[year week],"Average",[Average],"Attribute","Unit","Value",[Unit])
)

which then results in a visual like this

see attached.

Hi lcfaria ,

Please check if this blog could help you: Dynamic EVERYTHING (measures, axis, legend, titles... - Microsoft Power BI Community.

This blog shows layered dynamic DAX measures, i.e. how one chart can show different values, in different time frames, different scale. Report also shows how a slicer can be used to dynamically change axis and legend. Report has dynamic title and switch for chart types. Database layout is quite simple (and can be used for other cases) but uses a bit of trickery to create such dynamic solution using slicers to change axis/legend. 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.