Forum Discussion

PascalCL's avatar
PascalCL
Frequent Visitor
4 years ago
Solved

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?
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    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's avatar
amitchandak
Super User
4 years ago

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's avatar
PascalCL
Frequent Visitor
4 years ago

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