Change measure format with IF statement

[Anonymous]

Hello,

I have a measure with IF statement. but I can not change format,. it seems text when I check on the top. and there is no other option to change. I checked all 2 input format from the database. but all are whole number on Power BI.   

Thank you in advance 

Baris 

[Anonymous]

Hello

Thank you but,

actually I'd like to see total spikes and non spikes under the table but I can not. also I have changed the format as whole number but I can still not see.

Regards

[DataNinja777]

Hi @Anonymous ,

Your if statement output is text (i.e., "Non", "Spike"), therefore, there is no option other than text.  

Best regards,