Forum Discussion

Krish89's avatar
Krish89
Helper II
5 years ago
Solved

Remove rows with the value 0 in Matrix visual

Hi Power BI Community,   I have a PBI report where I would like to plot the sales data based on the Electonics type for each month.. I have a table "ElectronicsSales" with a column called "Electro...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Krish89 ,

    Try a measure like 

    Measure =

    var _1 =Sum( ElectronicSales[Revenue] )

    return

    if(_1=0 , blank(), _1)

amitchandak's avatar
amitchandak
Super User
5 years ago

Krish89 ,

Try a measure like 

Measure =

var _1 =Sum( ElectronicSales[Revenue] )

return

if(_1=0 , blank(), _1)

  • Krish89's avatar
    Krish89
    Helper II
    5 years ago

    amitchandak ,

     

    Thank you very much for quick response and it helped.

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      5 years ago

      Hi Krish89 ,

       

      Just use the following measure:

       

      Sales Revenue= Sum( ElectronicSales[Revenue] )+0

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      Best Regards,

      Dedmon Dai

  • SuruboiR's avatar
    SuruboiR
    New Member
    3 years ago

    could u pls share measure DAX formula again, given formula is not working.