Forum Discussion
New column calculated by grouping
Hello gents, I have a table, which contains few columns, which I use to drill through visualizations. I want to create a new calculated column, which will be looking into "A1" and "Status". Can yo...
Jihwan_Kim
Super User
Super User
Expected result CC : =
VAR _currentAone = 'Table'[A1]
VAR _filtertable =
FILTER ( 'Table', 'Table'[A1] = _currentAone )
VAR _selectstatuscolumn =
SELECTCOLUMNS ( _filtertable, "@status", 'Table'[Status] )
RETURN
SWITCH (
TRUE (),
"Not Good" IN _selectstatuscolumn, "Not Good",
NOT ( "Not Good" IN _selectstatuscolumn ), "Good"
)