Forum Discussion

Scala's avatar
Scala
Frequent Visitor
3 years ago
Solved

Using aggregate (sum) in visuals is removing rows

Hello everyone! I've run into some behaviour in PowerBI I don't quite understand, which makes it difficult to figure out how to work around it. I have a table that has some master data for materials....
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Scala , Add +0 in your measure

     

    sum(Table[Amount]) +0

     

     

    or use the option in visual, show item with no data

     

amitchandak's avatar
amitchandak
Super User
3 years ago

Scala , Add +0 in your measure

 

sum(Table[Amount]) +0

 

 

or use the option in visual, show item with no data

 

Scala's avatar
Scala
Frequent Visitor
3 years ago

Thanks very much!