Forum Discussion

utsavlexmark's avatar
utsavlexmark
Icon for Helper III rankHelper III
7 years ago
Solved

Measure not showing the Total

Hello, I am working on a Power BI dashboard with lots of conditional values to be shown. In the process I found a obsrtuction and need help to overcome that. I have created one measure as follows: ...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi utsavlexmark 

    Cretae a measure

    QTY Need 2 =
IF (
    HASONEVALUE ( 'Table'[partnumber] ),
    IF ( [QTY Need v1] < 0, 0, [QTY Need v1] ),
    SUMX ( ALL ( 'Table'[partnumber] ), [QTY Need] )
)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi utsavlexmark 

Create a measure

QTY Need =
IF (
    HASONEVALUE ( 'Table'[partnumber] ),
    IF ( [QTY Need v1] < 0, 0, [QTY Need v1] ),
    SUMX ( ALL ( 'Table'[partnumber] ), [QTY Need v1] )
)

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • utsavlexmark's avatar
    utsavlexmark
    Icon for Helper III rankHelper III
    7 years ago

    Hello,

    Thanks for the reply, but the total is in negetive figure. I want the total should be showing the sum of positive values only. 

    As per the logic - the values of "QTY Need" are either 0 (negetive values will be shown as 0) or positive values. I want the sum of those positive values only.

    Regards

    Utsav

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi utsavlexmark 

      Cretae a measure

      QTY Need 2 =
IF (
    HASONEVALUE ( 'Table'[partnumber] ),
    IF ( [QTY Need v1] < 0, 0, [QTY Need v1] ),
    SUMX ( ALL ( 'Table'[partnumber] ), [QTY Need] )
)

       

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • utsavlexmark's avatar
        utsavlexmark
        Icon for Helper III rankHelper III
        7 years ago
        Although little complected - but still acceptable as it is solving my problem. At least it will give me a time to find any other possible solution. Thank you very much @v-juanli-msft. Regards Utsav