Forum Discussion
Help for a complex calculated column
Anonymous you can add new measure with following expression
Market Sales = CALCULATE( SUM( Table[Coloumn] ), Table[City] = "Market" )
It is not a solution. If a apply this I'll get the sum of all Market lines. I want to get the Market for the same country.
Example:
France Market 10000
France Paris 5000
Germany Market 20000
Germany Berlin 5000
I want this result:
France Market 10000 10000
France Paris 5000 10000
Germany Market 20000 20000
Germany Berlin 5000 20000
thks for your time anyway
Anonymous I assumed you have relationship between you tables and it would work. Seems like you just showed one table in your original post. It help if you provide sample data and how your data model is. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490I have only one table
Anonymous share sample data in excel.