Solved: DAX help: To omit series of 0s in the data

Anonymous · ‎07-07-2022

I have to write a DAX measure that would skip a series of 0s in the data which does not have any value other than 0 after its occurrence.

Ex: For the below data, the data measure should only show data from 2021 to 2028 on a line chart

GilbertQ · ‎07-07-2022

Hi @Anonymous

This is how you should create your sales measure as shown below. If your measure is based of a column called "Total Sales Amount"

Sales = IF(SUM('Table Name'[Total Sales Amount]) = 0, BLANK(),SUM('Table Name'[Total Sales Amount]))

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

GilbertQ · ‎07-07-2022

Hi @Anonymous

This is how you should create your sales measure as shown below. If your measure is based of a column called "Total Sales Amount"

Sales = IF(SUM('Table Name'[Total Sales Amount]) = 0, BLANK(),SUM('Table Name'[Total Sales Amount]))

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

DAX help: To omit series of 0s in the data