cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Radkos Regular Visitor
Regular Visitor

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
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


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

Proud to be a Datanaut!