Forum Discussion

MaxwellB's avatar
MaxwellB
New Member
2 years ago
Solved

DAX Recategorise

Hi All,   I am hoping to get a quick hand on how to create a DAX column in my model.   I am looking to recategorise Individual rows with a DAX expression where a user could fall into one of two c...
category
DAX
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, MaxwellB 

    try below code for column 

    Column = 
var category_value = CALCULATETABLE(VALUES('Table (2)'[Category]),ALL('Table (2)'[Category]))
RETURN
IF("A" in category_value,"A",'Table (2)'[Category])

     

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, MaxwellB 

try below code for column 

Column = 
var category_value = CALCULATETABLE(VALUES('Table (2)'[Category]),ALL('Table (2)'[Category]))
RETURN
IF("A" in category_value,"A",'Table (2)'[Category])

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MaxwellB's avatar
    MaxwellB
    New Member
    2 years ago

    Amazing thank you! ğŸ˜Š