The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
@Anonymous
You may try to use ALLSELECTED.
AVERAGEX (
ALLSELECTED ( 'Table'[ISIN] ),
@Anonymous
You may try to use ALLSELECTED.
AVERAGEX (
ALLSELECTED ( 'Table'[ISIN] ),
Is there a relationship between those two tables?
There is a relationship between the sectors and everything is linked through ISINs
I think you need to use ALLEXCEPT or Refer:
https://community.powerbi.com/t5/Desktop/Calculate-Average-per-category/td-p/362637
https://community.powerbi.com/t5/Desktop/highest-value-by-category/td-p/428758