Forum Discussion

powerbr's avatar
powerbr
Frequent Visitor
5 years ago

Measure stops filtering when converted into text

I have the following measure that works properly until d, however, after I apply the last transformation it breaks and stops applying my report filters. Any ideas on why this could be happening?   ...
Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi powerbr ,

Can you expand on "it breaks and stops applying my report filters"?

Please provide screenshots of how are you applying those report filters in your visualization?

Regards,

powerbr's avatar
powerbr
Frequent Visitor
5 years ago

Payeras_BI 

Thanks for the support.

The datamodel is quite simple:

(Note that the masure is contained in the values table)

Both tables are connected through TestID, being Testinformation the DimTable.
I have a slicer with TestID inside the report, set up to, when I use the measure without converting it into text, the Values table successfully gets filtered by TestID; however, when I return the text values, the measure returns all TestID values ignoring the filter.

I resorted to changing the pipeline, but I still wonder if I am missing something from this specific DAX behaviour.

 

 

  • Payeras_BI's avatar
    Payeras_BI
    Solution Sage
    5 years ago

    Hello powerbr ,

     

    If I understood well, at the end of your code, I would substitute:

     

    RETURN r

     

    by 

     

    RETURN
    IF(NOT ISBLANK(d),r)

    Regards,

    • powerbr's avatar
      powerbr
      Frequent Visitor
      5 years ago

      I will try this today.

      Sorry for the late response, I changed my datapipe to accomodate for the data I want to display and reduce some modelling in PowerBI.