cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Guille2711410
Helper I
Helper I

DAX measures: operator with two tables

Hi, everyone

I have this measure that works very well, but I want to add calculation.

PenMdoRec = ROUND(SUMX(SUMMARIZE(COMTO20,COMTO20[CTAUNICA]),

                                 CALCULATE(MAX(COMTO20[RECNROTRN]),

                                  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

Thank you

7 REPLIES 7
kentyler
Solution Sage
Solution Sage

Can you post a picture of your data schema ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Hi Kentyler

If this one you want

 

I'm sorry

Attach the schema from Insert Photos, but you can´t see

Schema.jpg

It looks like RELATED should work. Can you share a small version of the power bi file ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


 Ok

I have a small version but I dont know attach the file PBIX

Please help me.

Thank

Ok

This is a small sample, the original table has more than 150 million of records with more than 40 fields.Small version.jpg

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

Thanks

Ken Tyler





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!