Forum Discussion

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? ...

Frequent Visitor

5 years ago

TestInformation[desirability_] are numbers.

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

Icon for Solution Sage rank

Solution Sage

5 years ago

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
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
  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
    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.

Related content