Forum Discussion

Krzysiek's avatar
Krzysiek
New Member
8 years ago

Grouping 1 value into 2 groups

Hi! I have a table like 1., I know how to do 2. and I would like to do something like 3. Could you help me? I have no clue how to do it. For example, I want to count rows with A - the result shou...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Krzysiek,

 

I'm afraid we can't do like that. But we can create some measures. What's your real scenario?

countA =
CALCULATE (
    COUNT ( Table1[Letter] ),
    SEARCH ( "A", 'Table1'[Letter], 1, 0 ) > 0
)

countB =
CALCULATE (
    COUNT ( Table1[Letter] ),
    SEARCH ( "B", 'Table1'[Letter], 1, 0 ) > 0
)

countAB =
CALCULATE (
    COUNT ( Table1[Letter] ),
    FILTER (
        'Table1',
        SEARCH ( "A", 'Table1'[Letter], 1, 0 ) > 0
            || SEARCH ( "B", 'Table1'[Letter], 1, 0 ) > 0
    )
)

Grouping_1_value_into_2_groups

 

Best Regards,

Dale