Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Show items with no data as 0

Hi, Need some help to show 0 for records with no data ,  used logic below  but not working as expected. Approach 1         SalesQty = Coalesce( SUM(Qty),0) Approach 2         SalesQty = SUM(Qty)...
Need Help
onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
5 years ago

Hello

Review your model, type of relationship and direction. 

 

Best regards  

Anonymous's avatar
Anonymous
Not applicable
5 years ago

relationship and filter directions are fine , working as expected when used with other measures .

Its just when logic is modified to records with no data as 0 its not working as expected.

 

I can just use show no data approach but wanted to check if we can fix it using measure.

 

https://data-mozart.com/why-you-should-not-replace-blanks-with-0-in-power-bi/

 

thanks

 

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant
    5 years ago

    Hello

     

    try 

    Approach 3 

         SalesQty = IF( SUM(Qty)= Blank(), 0, SUM(Qty))

     

    If it doesn't work, send image of the model

     

    best regards