Solved: i have infinity values, then converting that colum...

Anonymous · ‎05-11-2023

Hi

considering the title of the topic and the image below,

How i can solve this considering i dont want to delete rows with errors.

edhans · ‎05-11-2023

The fastest way is to select that column, click the dropdown next to Replace Values, and select Replace Errors. Replace them with 0 or null. The word "null" will show up as a value in italics, and is equivalent to a blank in DAX. A zero might be better, but your call.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

edhans · ‎05-11-2023

The fastest way is to select that column, click the dropdown next to Replace Values, and select Replace Errors. Replace them with 0 or null. The word "null" will show up as a value in italics, and is equivalent to a blank in DAX. A zero might be better, but your call.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Anonymous · ‎05-12-2023

Ty vry much

i have infinity values, then converting that column to percentage i got error, how to deal with this

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024