cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Summaring data from a sumx measure in different table

Hi,

I created a table that is similar to the one below:

 

16112018 SUM AGING 1.PNG

 

Now I wrote a measure with sumx, that take values from a column An(|n is indicated by parameter) and Cm(same for m) and calculate (A-C)*P. Then i created a table with Country, Material and measure and filtered that measure is always greater than 0. Now i want to create a measure that will sum up all my values from measure(greater than 0) and i would like also to do a table with summarizing value with measure for every country.

 

16112018 SUM AGING 2.PNG16112018 SUM AGING 3.PNG

 

Is it possible? should i build table in other way, or do some other measures? Please let me know.

Thank you in advance for responce.

Radkos

1 REPLY 1
Highlighted
Super User
Super User

Re: Summaring data from a sumx measure in different table

Should be possible. See if this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 105 members 1,400 guests
Please welcome our newest community members: