Forum Discussion
Wrong Subtotals Matrix
Hello everyone,
First of all, I promise you that I've been using the searchbar but I couldn't find a proper answer.
I have the following graph, and I simply cannot get a proper subtotal. For instance, check out "AIROX". It says 82, but clearly is not the right sum.
The measure is the following one:
Finally with our consultant we arrived to the solution: We had to disable the relationship bewtween the calendar table (Dim Date) and the Fact Table (Fact Stock Equipos). This allowed us to have a proper subtotal, and in order to keep things ok with the original measures, I just add USERELATIONSHIP on them.
Anyway, thanks a lot for your kindness and help,
23 Replies
Hello okusai3000 ,
Check this video for your solution.
https://www.youtube.com/watch?v=ufHOOLdi_jk
Greets,Ronald
okusai3000 , Try like
CALCULATE(Sumx(filter(values('Dim Descripcion Equipos y Fungibles'[Marca]);[*Antiguedad]<-180);[*Cant Equipos]))
amitchandak , Didn't work. I mean, is still showing the same.
Ronald123 , I already followed her video and she talks about the use of HASONEVALUE. If I use that, it also doesn't work.
okusai3000 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
okusai3000 Have you read through this? This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907You would need to SUMMARIZE or GROUPBY on both of the columns in your rows hiearchy of your matrix.
- Can you please share your model view? Looks like you're using two tables in this matrix - Fact Equipos and Dim Descripcion Equipos y Fungibles. Which table is Cant Equipos doing a count from?
Anyone ? 😞
