How to replace 0 values to measure

[Akshay123]

Hi Experts

I have data like below and it's direct fields from the source, I have created measures for Jan to Dec months.

If flaw_cnt is blank or 0 value need to replace it with my particular month measure or if it is <> 0 or Blank it has to load the actual value.

[Anonymous · Accepted solution]

Hi @Akshay123 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create a measure. 

New Measure = IF(SUM('Table'[flaw_cnt])= BLANK() ||SUM('Table'[flaw_cnt])=0,[Yourmeasure],SUM('Table'[flaw_cnt]))

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. 

Best Regards,

Neeko Tang

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

[Kedar_Pande]

FLAW_CNT_REPLACE= if(flaw_cnt=blank() || flaw_cnt=0, [Your measeure for months],flaw_cnt)

Let me know if this helps

[Akshay123]

Hi @Kedar_Pande 
Thanks for your response, it will not work.
My appoach I am looking, I need to validate all the months and return the value

for ex :
var a = if(month = 1, sum(flaw_cnt) 
var b = if(month = 2, sum(flaw_cnt)

.

.

.

var c =  if(month = 12, sum(flaw_cnt) 

Return

if (a = 0, My measure, a)
But i am unable to return all months value

[Kedar_Pande]

Hi @Akshay123 ,
How month and flaw_cnt is related?
Can you share the pbix file?

[Akshay123]

Hi @Kedar_Pande 

Can't attach any files here, I have some limitations.
It's just like sales amout, which month how much of sales happend.

Till April have data, rest of the months are preductive count.