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