Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column filter - for grouping rows

Hi!   I want to create a calculated column in tabular editor which will be used as a filter in reports. You could say, what I want to achieve, is a type of grouping of rows. I want to create "Order...
calculated column
Need Help DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    please try

    Order Type Head =
IF (
    COUNTROWS (
        CALCULATETABLE (
            VALUES ( 'Table'[Order type row] ),
            ALLEXCEPT ( 'Table', 'Table'[Order head] )
        )
    ) = 1,
    'Table'[Order type row],
    "Mixed"
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

please try

Order Type Head =
IF (
    COUNTROWS (
        CALCULATETABLE (
            VALUES ( 'Table'[Order type row] ),
            ALLEXCEPT ( 'Table', 'Table'[Order head] )
        )
    ) = 1,
    'Table'[Order type row],
    "Mixed"
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tamerj1, thanks for your answer! It's working like a charm 😄