Forum Discussion

drivero's avatar
drivero
Helper I
2 years ago
Solved

Measure to Isolate Negative values group by

Hi there!

 

I would like to Isolate the total value Group by Country which are negative in global:

 

 

In this case, like Italy's Total is negative, I would like to be shown as 0 and then the TOTAL should be 839578 + 25000 (because -25000 should be = 0)

I could visualize italy in total as 0, but still the total still containing the -25000

 

I attach a sample desktop project (https://we.tl/t-4JW0UHBxKN).

 

I need help, please. 

 

Thank you very much.

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    One approach is to check if country is in scope (false for the total line):

    IF (
    ISINSCOPE ( DimCustomer[Country] ),
    [TotalAmount],
    SUMX ( VALUES ( DimCustomer[Country] ), [TotalAmount > 0] )
)

3 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    2 years ago

    One approach is to check if country is in scope (false for the total line):

    IF (
    ISINSCOPE ( DimCustomer[Country] ),
    [TotalAmount],
    SUMX ( VALUES ( DimCustomer[Country] ), [TotalAmount > 0] )
)
    • drivero's avatar
      drivero
      Helper I
      2 years ago

      AlexisOlson 

       

      Thanks!
      Now, the total Amount is correct but I would like as well to show 0 the negative values in the visual (group by country)

      Is it posible?

      I would like to show Italy 0 but the total sum like the one measure you gave me 🙂

  • drivero's avatar
    drivero
    Helper I
    2 years ago

    Hi AlexisOlson 

    I achieve what I want:

     

    IF (
    ISINSCOPE ( DimCustomer[Country] ),
    [TotalAmount > 0],
    SUMX ( VALUES ( DimCustomer[Country] ), [TotalAmount > 0] )
)

     

    Thank you very much for your help 🙂 !!