Resources Exceeded Issue on Condition Check

[ak77]

Hi all,

I need to hide the rows where all the column cell values are zero. so i used the below DAX where i am checking if round of each meausre value is 0 and using visual filter to filter for all valuesw which gives 0 

if ((round([MTD-V1],2)= 0 && round([YTD-V1],2)= 0 && round([QTD-V1],2)= 0 && round([FYTD-V1],2)=0 &&
round([Qtr-V1],2)=0 && round([Qtr (T-1)-V1],2)=0 && round([Qtr (T-2)-V1],2)=0 &&round([Qtr (T-2)-V1],2)=0),0,1)

This works in desktop but when published gives Resources Exceeded Issue . Any other way if this conditional check can be achieved? Please help

[parry2k]

@ak77 why you are checking zero? does your measure return zero? Provide full details. Measure usually returns blank () if no data is found until you are forcing measure to return zero. It is hard to provide any solution without knowing the full details. 

[parry2k]

@ak77 now I'm thinking a bit about why you need to do this check, if all measures return blank () values, the row will be suppressed automatically. 

[ak77]

i am checking for zero here... not blank .. if all column cell values are zero.. hide it .. is there a easiest way pls let me know

[parry2k]

@ak77 try this 

INT(round([MTD-V1+[YTD-V1]+[QTD-V1]+[FYTD-V1]+[Qtr-V1]+[Qtr (T-1)-V1]+[Qtr (T-2)-V1]+[Qtr (T-2)-V1],2) >= 0
)

 

[ak77]

Hi @parry2k , thanks ,,m i tried.. i have a logic of dis[playing -- character if  columns are blank..

its breaking there with the below error