Forum Discussion
souvik900766
Helper IV
Helper IVSubtotal issue using summarize and sumx
Hi, My measure using sumx and summarize showing values at market level 0. I wanted to add all the market numbers to get the OU total ,the markets are coming zero and OUs also My OU and Market come...
VahidDM
Super User
Super UserHi souvik900766
SUMX(<table>, <expression>)
Change the expression part of your formula to [_1] then check the result.
please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/
souvik900766Helper IV
Helper IVHi VahidDM ,
Here is the file,
Kindly help, urgently needed.
https://www.dropbox.com/s/7oq1viv0f7of033/Total%20error.pbix?dl=0