Forum Discussion
Totel Sum worg
Hi I have the problem
When I display the total sum of the measure, the result does not right.
how can i fix this?
Hi PascalCL
Thanks for reaching out to us.
This is a typical problem, please try this, create 2 measures,
Vorschlag CT 2 = IF ( SUM ( 'Sales invoices 2021/2022 (2)'[Quantity] ) = 0, BLANK (), DIVIDE ( SUM ( 'Sales invoices 2021/2022 (2)'[Quantity] ) - 'Item'[Theoretischer Vorrat], SUM ( 'Item'[Anz. / Paket] ) ) )totalrow= IF(ISFILTERED('Table'[name]),[Vorschlag CT 2],sumx('Sales invoices 2021/2022 (2)',[Vorschlag CT 2]))Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
v-xiaotangCommunity Support
Hi PascalCL
Thanks for reaching out to us.
This is a typical problem, please try this, create 2 measures,
Vorschlag CT 2 = IF ( SUM ( 'Sales invoices 2021/2022 (2)'[Quantity] ) = 0, BLANK (), DIVIDE ( SUM ( 'Sales invoices 2021/2022 (2)'[Quantity] ) - 'Item'[Theoretischer Vorrat], SUM ( 'Item'[Anz. / Paket] ) ) )totalrow= IF(ISFILTERED('Table'[name]),[Vorschlag CT 2],sumx('Sales invoices 2021/2022 (2)',[Vorschlag CT 2]))Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
PascalCL , You measure might be using row context.
You need a measure like, using column in visual and your measure
sumx(summarize(Table, Table[Col1], Table1[Col2],"_1", [Measure]) , [_1])
Refer to this video if needed
Unfortunately, I do not quite get along with it...
here the measure with which I work.
Vorschlag CT 2 =IF(SUM('Sales invoices 2021/2022 (2)'[Quantity]) =0,BLANK(),DIVIDE(SUM('Sales invoices 2021/2022 (2)'[Quantity]) - 'Item'[Theoretischer Vorrat],SUM('Item'[Anz. / Paket])))
