Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Help when you know. Ask when you don't!
Join Zoom Meeting
https://zoom.us/j/93772385904
Help when you know. Ask when you don't!
I just sent you the meeting invitation
Help when you know. Ask when you don't!
What time work for you ? I'm in PST zone.
Help when you know. Ask when you don't!
Hello Sir,
My Work time is IST Zone,
So please confirm your available time, so we both discuss about the query.
Thanks
Aditya
Looks like we're having trouble matching times. I'm available from 7:00 am to 9:00 pm PST
Help when you know. Ask when you don't!
Hello,
Tommrow we will catch up on your time. I will use the same zoom meeting request.
Thanks.
Aditya
Help when you know. Ask when you don't!
Hello,
Yes, I am confirm the time. So please share the link we can discuss further.
Thanks
Aditya
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,...
Help when you know. Ask when you don't!
Join Zoom Meeting
https://zoom.us/j/92083393962
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |