cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Calculating Subtotal using DAX -- Need Help

Hello ALL,

I am facing one challenge while calculation of Subtotal values.

My query is Calculate Subtotal using the below rows data but whatever the data come from Fact Table all in the rows, data value should be same and Subtotal value to be same. Please refer the screen shot for your reference.

My Table should be Matrix Table

Subtotal.JPG

Subtotal wont be caluclated above level it should be gave me the averge value

I have 6 subtotal rows, now I present One rows, another 5 Subtotal is need to add or may be more. Any help much appreciated.

 

Any query, please feel free to contact. or reply. I will explain to you more. Thanks in advance.

12 REPLIES 12
Highlighted
Super User II
Super User II

Re: Calculating Subtotal using DAX -- Need Help

You should be able to use a function like ISINSCOPE. If you'd like to do an online session so you can explain what you need in detail, send me an email. I'll send you an invitation to a Zoom meeting. I'm ken at 8thfold dot com

 





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Helper I
Helper I

Re: Calculating Subtotal using DAX -- Need Help

Hello Sir,

 

Please sent me the detail on hotmail.com

gaditya12@hotmail.com

 

thanks

aditya

Highlighted
Super User II
Super User II

Re: Calculating Subtotal using DAX -- Need Help

I just sent you the meeting invitation





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Super User II
Super User II

Re: Calculating Subtotal using DAX -- Need Help

What time work for you ?  I'm in PST zone.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Helper I
Helper I

Re: Calculating Subtotal using DAX -- Need Help

Hello Sir,

 

My Work time is IST Zone,

So please confirm your available time, so we both discuss about the query.

 

Thanks

Aditya

 

Highlighted
Super User II
Super User II

Re: Calculating Subtotal using DAX -- Need Help

I'm going to start a meeting and send you an invitation.  Here is a helpful link https://www.daxpatterns.com/parent-child-hierarchies/#:~:text=DAX%20does%20not%20directly%20support,...





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Super User II
Super User II

Re: Calculating Subtotal using DAX -- Need Help

Join Zoom Meeting
https://zoom.us/j/92083393962





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Super User II
Super User II

Re: Calculating Subtotal using DAX -- Need Help

Looks like we're having trouble matching times. I'm available from 7:00 am to 9:00 pm PST





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Helper I
Helper I

Re: Calculating Subtotal using DAX -- Need Help

Hello, 

 

Tommrow we will catch up on your time. I will use the same zoom meeting request.

 

Thanks.

Aditya

 

 

 

 

 

 

 

 

 

 

 

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors