Forum Discussion

ak77's avatar
ak77
Post Patron
2 years ago

Resources Exceeded Issue on Condition Check

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

 

Need Help
Show and Tell

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    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's avatar
      ak77
      Post Patron
      2 years ago

      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

       

       

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    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's avatar
      ak77
      Post Patron
      2 years ago

      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's avatar
    parry2k
    Super User
    2 years ago

    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.