topic Re: Calculating Subtotal using DAX -- Need Help in DAX Commands and Tips

Calculating Subtotal using DAX -- Need Help

Anonymous — Mon, 29 Jun 2020 12:48:43 GMT

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

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Mon, 29 Jun 2020 14:01:11 GMT

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

Re: Calculating Subtotal using DAX -- Need Help

Anonymous — Mon, 29 Jun 2020 17:41:48 GMT

Hello Sir,

Please sent me the detail on hotmail.com

gaditya12@hotmail.com

thanks

aditya

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Mon, 29 Jun 2020 18:15:31 GMT

I just sent you the meeting invitation

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Mon, 29 Jun 2020 18:27:39 GMT

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

Re: Calculating Subtotal using DAX -- Need Help

Anonymous — Tue, 30 Jun 2020 03:27:42 GMT

Hello Sir,

My Work time is IST Zone,

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

Thanks

Aditya

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Tue, 30 Jun 2020 13:52:02 GMT

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,child%20hierarchy%20using%20calculated%20columns.

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Tue, 30 Jun 2020 13:53:56 GMT

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

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Tue, 30 Jun 2020 14:44:06 GMT

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

Re: Calculating Subtotal using DAX -- Need Help

Anonymous — Tue, 30 Jun 2020 18:29:38 GMT

Hello,

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

Thanks.

Aditya

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Tue, 30 Jun 2020 19:21:55 GMT

So, you're proposing 7:00 am PST ? Good. I closed the zoom meeting, I'll send you a new invitation in the morning.

Thanks

Ken Tyler

Re: Calculating Subtotal using DAX -- Need Help

Anonymous — Wed, 01 Jul 2020 08:03:58 GMT

Hello,

Yes, I am confirm the time. So please share the link we can discuss further.

Thanks

Aditya

Re: Calculating Subtotal using DAX -- Need Help

kentyler — Wed, 01 Jul 2020 14:04:41 GMT

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