Forum Discussion

MarDen94's avatar
MarDen94
Icon for Helper I rankHelper I
2 years ago
Solved

Summarize multiple columns in one slicer

Hi,    I've got a question regarding some DAX-logic to create a slicer.  I am working with a table similar to this one:    ID Option1 Option2 Option3 1 TRUE TRUE FALS...
  • _elbpower's avatar
    _elbpower
    2 years ago

     

    CountIds =
VAR SelectedOptions =
    CONCATENATEX(VALUES('Calculation group'[Calculation group column]), 'Calculation group'[Calculation group column], ", ")
VAR A = SUMMARIZE('Fact', 'Fact'[ID], "values",
    IF(
        (CONTAINSSTRING(SelectedOptions, "Option 1") && VALUES('Fact'[Option1]) = TRUE()) ||
        (CONTAINSSTRING(SelectedOptions, "Option 2") && VALUES('Fact'[Option2]) = TRUE()) ||
        (CONTAINSSTRING(SelectedOptions, "Option 3") && VALUES('Fact'[Option3]) = TRUE()),
        1,
        0
    )
)
VAR DistinctIDs = SUMMARIZE(FILTER(A, [values] = 1), [ID])
RETURN COUNTROWS(DistinctIDs)

     

     

     

_elbpower's avatar
_elbpower
Icon for Resolver III rankResolver III
2 years ago

 

CountIds =
VAR SelectedOptions =
    CONCATENATEX(VALUES('Calculation group'[Calculation group column]), 'Calculation group'[Calculation group column], ", ")
VAR A = SUMMARIZE('Fact', 'Fact'[ID], "values",
    IF(
        (CONTAINSSTRING(SelectedOptions, "Option 1") && VALUES('Fact'[Option1]) = TRUE()) ||
        (CONTAINSSTRING(SelectedOptions, "Option 2") && VALUES('Fact'[Option2]) = TRUE()) ||
        (CONTAINSSTRING(SelectedOptions, "Option 3") && VALUES('Fact'[Option3]) = TRUE()),
        1,
        0
    )
)
VAR DistinctIDs = SUMMARIZE(FILTER(A, [values] = 1), [ID])
RETURN COUNTROWS(DistinctIDs)

 

 

 

MarDen94's avatar
MarDen94
Icon for Helper I rankHelper I
2 years ago

Thanks, this was the solution I was looking for