Forum Discussion

Youngmi's avatar
Youngmi
Frequent Visitor
4 years ago
Solved

Time intelligence quick measures fails when use a Relative Date filter

Hi, Time intelligence quick measures fails when use a Relative Date filter on this page or all pages. the date column is the same column used in the quick measure. it works ok without the relative d...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Youngmi ,

     

    You have a DAX named ERROR() in your expression. And if you do some change in the filter on this page by this column you specified, the result of  ISFILTERED() will be a TRUE, so it will run the ERROR() function.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Youngmi ,

 

You have a DAX named ERROR() in your expression. And if you do some change in the filter on this page by this column you specified, the result of  ISFILTERED() will be a TRUE, so it will run the ERROR() function.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Youngmi's avatar
    Youngmi
    Frequent Visitor
    4 years ago

    I removed the ERROR() portion and it shows MoM with the date page filter. Thank you. 

  • dstoma's avatar
    dstoma
    Frequent Visitor
    3 years ago

    This really works for people?   I can remove the error statement, but it doesn't change the fact that a problem exists.  I tried to include the measure on a line + clustered column visual, but it doesn't appear.  The error statement indicates that a problem exists, but the statement itself isn't the problem.  I'm surprised that merely removing the error statement fixes this for some people.