Group wise Count measure

[Anonymous]

hi Experts,

i have data like below

Group name	Dealer
Group1	2100
Group1	9435
Group1	3254
Group1	2143
Group2	5443
Group2	4524
Group2	6455
Group3	7544
Group3	4325
Group3	4354
Group3	6543

now i have one slicer as a Dealer, whenever i selected value from dealer slicer i want to show entire dealer group count number.

EX: i selected 2100 dealer from slicer then measure should show 4 (because 2100 value we have in group1 so we need group1 Count)

thanks & regards

Don

[jdbuchanan71]

If you want it to work when selecting multiple Dealers we can do it like this instead.

Group Count = 
VAR _Group =
    DISTINCT ( 'Table'[Group name] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        REMOVEFILTERS ( 'Table'[Dealer] ),
        _Group
    )

[jdbuchanan71 · Accepted solution]

@Anonymous 

Try this.

Group Count = 
VAR _Group =
    SELECTEDVALUE ( 'Table'[Group name] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        REMOVEFILTERS ( 'Table'[Dealer] ),
        'Table'[Group name] = _Group
    )