cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
Alejandro-Glez
Helper III
Helper III

Total revenue with RELATED doesn't work

‎10-13-2020 11:53 PM

Good afternoon

I am trying to calculate the total revenue using DAX, so I try to multplicate with the SUMX the amount of sales of the Fact Ventass by the unit price of the DimProduct, with RELATED. However, it does not work for me even though the model is related to the ProductKey.

Thank you and greetings.

https://gyazo.com/a9584557a50395ef4e8d34f16260a175

https://gyazo.com/659db086264438b055bacc109cc4a8c8

Message 1 of 3
154 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎10-14-2020 12:12 AM

@Alejandro-Glez , Move Related inside the sumx and try

example

Sumx(Table, Table[col]* related(dim[Value]))



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || Learn 50+ Power Query List Functions
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

View solution in original post

Message 2 of 3
125 Views
2 REPLIES 2
amitchandak
Super User
Super User

‎10-14-2020 12:12 AM

@Alejandro-Glez , Move Related inside the sumx and try

example

Sumx(Table, Table[col]* related(dim[Value]))



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || Learn 50+ Power Query List Functions
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!
Message 2 of 3
126 Views
Alejandro-Glez
Helper III
Helper III
In response to amitchandak

‎10-14-2020 01:21 AM

It worked!

 

Thanks.

Message 3 of 3
113 Views
0

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

View All