Measure stops filtering when converted into text

Question

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?

Many thanks!

payeras_bi · Answer

Hi&nbsp;powerbr&nbsp;,Are TestInformation[desirability_...] columns formated as numbers?Can, in any case, the result of d be &gt; 9?Regards,

powerbr · Answer

Hi&nbsp;Payeras_BI&nbsp;TestInformation[desirability_] are numbers.They will never be &gt; 9, I control that through my pipeline.&nbsp;&nbsp;

payeras_bi · Answer

Hi&nbsp;powerbr&nbsp;,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 · Answer

Payeras_BI&nbsp;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&nbsp;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.&nbsp;&nbsp;

payeras_bi · Answer

Hello&nbsp;powerbr&nbsp;,&nbsp;If I understood well, at the end of your code, I would substitute:&nbsp;RETURN r&nbsp;by&nbsp;&nbsp;RETURNIF(NOT ISBLANK(d),r)Regards,

Forum Discussion

Measure stops filtering when converted into text

7 Replies

Related content

Dynamic measure filtering

Convert measure to column

Filter by Rank measure

Convert calculated column into measure

Convert column to measure