I have this measure that works very well, but I want to add calculation.
PenMdoRec = ROUND(SUMX(SUMMARIZE(COMTO20,COMTO20[CTAUNICA]),
ALLEXCEPT(COMTO20,COMTO20[CTAUNICA]))) / 11,2)
To this result I want to divide it by the TOTAL field of another table called SUNEDU and get the desired value.
Both tables (COMTO20 and SUNEDU) are related by the UNIVERSITY field
I tried RELATED function and it doesn't work.
I will appreciate your help
I'm sorry, that is an image.
Could you just copy and paste the data into the post, so I can copy and paste it into Power BI
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!