Forum Discussion
PowerBI Slicing the data on multiple columns values
Created below measure and it is working
VAR SelectedOptions =
CONCATENATEX(
ALLSELECTED('SlicerRequest-Selection'),
'SlicerRequest-Selection'[MeasureName],
","
)VAR SuburbRecords =
CALCULATETABLE (
'Table_Fact',CONTAINSSTRING(SelectedOptions, "Suburb") &&
'Table_Fact'[Suburb]="Yes"
)VAR streetRecords =
CALCULATETABLE (
'Table_Fact',
CONTAINSSTRING(SelectedOptions, "street") &&
'Table_Fact'[street] ="Yes"
)
VAR AreaRecords =
CALCULATETABLE (
'Table_Fact',
CONTAINSSTRING(SelectedOptions, "Area") &&
'Table_Fact'[Area] ="Yes"
)VAR ZoneRecords =
CALCULATETABLE (
'Table_Fact',
CONTAINSSTRING(SelectedOptions, "Zone") &&
'Table_Fact'[Zone] ="Yes"
)RETURN
SUMX(DISTINCT( UNION (
SELECTCOLUMNS(SuburbRecords, "Suburb",1,"ID",'Table_Fact'[ID]),
SELECTCOLUMNS(streetRecords, "Street",1,"ID",'Table_Fact'[ID]),
SELECTCOLUMNS(AreaRecords, "Area",1,"ID",'Table_Fact'[ID]),
SELECTCOLUMNS(ZoneRecords, "Zone",1,"ID",'Table_Fact'[ID])
)),1)
Khushi , Better to unpivot this data and then create a measure with values yes and slicer with attribute
countrows(filter(Table, Table[Value] = "Yes" ))
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Actually it is combination of two table
| ID | Suburb | Street | Area | Zone | City |
| 1 | yes | no | no | no | no |
| 2 | yes | yes | no | no | no |
| 3 | no | yes | yes | yes | no |
| 4 | no | no | no | no | no |
| Id | IdName |
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
and the data is coming from AAS and this table is used at many place so i cann't pivot.