Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Repleacing blank() with zeros

I have a table with simple SUM measures, but i need to replace blanks with zeros. If I change measure with IF statement , it will remove filter applied to Machine column   withou IF   with ...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

Ok, I'm sorry, but I am still not understanding.

 

"An first printscreen you can see only some of Machines (filter applied at filter pane)" - Yes, but I don't know what that filter is. You provided a screen shot of a filter pane that has no filter selections.

 

"and all machines at second printscrees (filter is still on) because there is 0 in Scraps of All % measure"  - I don't see how your 0 scraps in all % meaure applies to the filter. If that measure returns blank, then by default you may/may not see machines because of how you have the data set. You can see in the image below you can show/hide items with "no data" which means blanks.

 

" but i need to display only Machines choose in filter" - What are you expecting to see exactly? That is a filter of machines. That is what you should see, only machines. I am not understanding.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I was wrong. thank you for you patience.

example:

i have two filter dimension: Machine Type, Machines (1:* relationship)

 

Table ("Machine" is from Machines table, filtred by MachineType table)

results:

I need 0's in all other colums for Drill01, WB01, WB04, WB08, WB12 machines

 

so if i change measure for Scraps of All %

from measure:

Scraps of All %:= DIVIDE( [Scraps], [All])

 

to measure:

Scraps of All %:= COALESCE(DIVIDE( [Scraps], [All]), 0)

(thank you for COALESCE)

 

result is:

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    i need a table only with Machines by MachineType filter (not in red square)

    • edhans's avatar
      edhans
      Community Champion
      6 years ago

      I'm sorry Anonymous - I cannot help. There is no MachineType field in the image so I cannot help you construct a filter based on a field I cannot see or know what is in it. You have to understand I have no idea what your model looks like or your data, beyond your screenshots. You have to provide specific and detailed info.

       

      How to get good help fast. Help us help you.
      How to Get Your Question Answered Quickly
      How to provide sample data in the Power BI Forum

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        edhans 
        of cource. thank you

         

        maybe this help:

         

        all measures:

        Production:= SUM( Production[ProducedParts] )

        Scraps:= SUM( Scrap[pocet] )

        All:= [Total Production] + [Total Scraps]

        Scraps of All %:= DIVIDE( [Scraps], [All] )

        Production of All%:= DIVIDE( [Production], [All] )

        model:

        * MachineCodebook = Machines (from my examples)

        I have put MachineType fied to table. now a see its wrong. By why 🤔