Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.