Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Dears,
I have come across a similar problem as the one described
here, but couldn't apply this to fix my case. I have a following matrix:
I want the highlighted column total to simply add up all the rows, which would give 3594.79 in this case.
the measures I use here are:
ДЗ вх. = sum('Sales(UnP)'[Объем, т]) * '01_Measures'[Цена (2)] * '01_Measures'[Отсрочка ДЗ] / sum(Dates[DaysQ])/1000
Отсрочка ДЗ = CALCULATE(AVERAGE('Incurred2(UnP)'[Прошлая отсрочка]); FILTER('Incurred2(UnP)';'Incurred2(UnP)'[Код позиции] = "2005/11103" || 'Incurred2(UnP)'[Код позиции] = "2005/1110909"); 'Incurred2(UnP)'[Тип обязательства]="Продажи")
Цена (2) =
SUMX('Sales2(UnP)'; 'Sales2(UnP)'[Цена] *
Calculate(
Values(
'Sales(UnP)'[Объем, т]);
Filter('Sales(UnP)';
'Sales(UnP)'[Группа продукции]='Sales2(UnP)'[Группа продукции] &&
'Sales(UnP)'[Контрагент]='Sales2(UnP)'[Контрагент])))
/sum('Sales(UnP)'[Объем, т])DaysQ calculates the no. of days in a chosen period.
I suppose the problem is in the formula for the main measure itself.
How should I change the formula to get the simple sum, not in total row context?
Thank you beforehand.
Regards,
Foyiq
Solved! Go to Solution.
the solution was quite simple, guys, in the measure, the partial SUM had to be changed to full SUMX. Piece of cake for everyone, but took me a day to realize the mistake))
the solution was quite simple, guys, in the measure, the partial SUM had to be changed to full SUMX. Piece of cake for everyone, but took me a day to realize the mistake))
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 56 | |
| 47 | |
| 44 | |
| 20 | |
| 20 |
| User | Count |
|---|---|
| 73 | |
| 72 | |
| 34 | |
| 33 | |
| 31 |