Totel Sum worg

[PascalCL]

Hi I have the problem 

When I display the total sum of the measure, the result does not right.

how can i fix this?

[v-xiaotang · Accepted solution]

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]

@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

https://www.youtube.com/watch?v=ufHOOLdi_jk

[PascalCL]

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])

     )

)