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
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,...
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.