Forum Discussion

sjelting's avatar
sjelting
Frequent Visitor
2 years ago
Solved

How to use Text column in Measure without aggregating

I have a data table with a date and text column. there are multiple rows for the same date. I want to display the rows in a table visual filtered on date. this works well, but I also want to have a "...
"DAX"
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sjelting ,

     

    Please try:

    Measure = 
IF (
    NOT ISFILTERED ( 'Table'[Column1] ),
    IF (
        MAX ( 'Table'[Column2] ) IN { "c", "d" },
        MAX ( 'Table'[Column1] ),
        BLANK ()
    ),
    IF ( ISFILTERED ( 'Table'[Column1] ), MAX ( 'Table'[Column1] ) )
)

     

    The final visual effect is shown below:

     

    pbix file is attached.

     

    If you have any further questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

sjelting's avatar
sjelting
Frequent Visitor
2 years ago

this wont work as it shows only one line if a filter is set even though there might be multiple rows and only the default text if its not set.