Forum Discussion

tjgamble's avatar
tjgamble
Regular Visitor
6 years ago
Solved

DAX: custom numeric format preventing table filter from working, is this by design?

Hello, I'm looking to understand if the behaviour I'm seeing with the "format" command in DAX with respect to table visual filtering is expected and if so is there a workaround?  What I'm trying to d...
  • FrankAT's avatar
    6 years ago

    Hi,

    your measure MeasureWithFormat returns in every situation a string and this is never blank.

    Use the properties settings inside the data model view. Select your measure and type your custom formatting as you would do in Excel:

     

     

    Regards Frank AT