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
    4 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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 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.