Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
5 years ago

Suprresing zero values

Hi , I am using below measures to get the result : WIP = SUMX(SUMMARIZE(Transactions, Transactions[PROJECT_NO], Transactions[FISCAL_PERIOD]),[WIP Amount])   WIP Amount = CALCULATE(sum(Transact...
kumar27's avatar
kumar27
Advocate V
5 years ago

Write is not 0.00

OR
use basic filtering and select all except 0.00

  • Priya2007's avatar
    Priya2007
    Frequent Visitor
    5 years ago

    Hi,

    It is a measure, I cant find basic filtering in that .

    • kumar27's avatar
      kumar27
      Advocate V
      5 years ago

      write 0.00 in place 0 at advanced filter

      • Priya2007's avatar
        Priya2007
        Frequent Visitor
        5 years ago

        Hi , I have tried that , but thats not working .