Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Experts,
Please help me with Dax measure, need a Subtotals for States and cities individually
Used
Total Sales = Calculate(SUM(table(sales),Allselected(table),Removefilters(Table(Cities))
With this im able to get answer if i filter for individual state and all cities belong to that state, But when i select more than 2 states getting total sum of those states,But my goal to get individual total sales like below snip
Hi @daxlearner
Please try
Total Sales =
CALCULATE (
SUM ( 'Table'[sales] ),
ALLEXCEPT (
'Table',
'Table'[State]
)
)
Thank You for reply @tamerj1 ,that measure gives Total States Sales,my goal to get State wide total,Ie Field value total.
Could you Please check below Post.
Not sure if I fully understand. Please try
Total Sales =
CALCULATE ( SUM ( 'Table'[sales] ), ALLSELECTED ( 'Table'[City] ) )
@Greg_Deckler ,Thank you very much for responding to my post.Please check details below
State | City | Sales | Actual Total Sales | Expected Total Sales |
California | San Francisco | 400 | 1000 | 600 |
California | Los Angeles | 200 | 1000 | 600 |
Florida | Tampa | 300 | 1000 | 400 |
Florida | Tampa | 100 | 1000 | 400 |
Hi, @daxlearner
Total Sales = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[State]))
Is this the outcome you expect? If not, please show the picture of your desired result.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@daxlearner Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
22 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
31 | |
23 | |
22 | |
22 |