Measure stops filtering when converted into text

[powerbr]

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!

[daxer-almighty]

@powerbr 

Please do yourself a favour and get rid of all these horrible IF's. There's a much better way: SWITCH.

[Payeras_BI]

Hi @powerbr ,

Are TestInformation[desirability_...] columns formated as numbers?

Can, in any case, the result of d be > 9?

Regards,

[powerbr]

Hi @Payeras_BI 

TestInformation[desirability_] are numbers.

They will never be > 9, I control that through my pipeline.

[Payeras_BI]

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]

@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]

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]

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.