cancel
Showing results for
Did you mean:
Post Patron

## Getting count of values that are selected on slicer

I have a column as 'NAme of the company' & I have created a slicer based on this column.

I have another column as 'secondary company'.

I added a card visual & on that I want to show the count of secondary company that is selected in the slicer.

If I selected company A on slicer & the company A is appearing 10 times in column Secondary company, I want the card to show the count as 10 as company A is available 10 times in 'Secondary company' column.

2 ACCEPTED SOLUTIONS
Solution Sage

Try this measure:

Count = CALCULATE(COUNT('Company data'[Secondary company]),ALLEXCEPT('Company data','Company data'[Secondary company]),'Company data'[Secondary company]=SELECTEDVALUE('Company data'[Main company]))

If I answered your question, please mark it as a solution to help other members find it more quickly.
Solution Sage

Not 100% sure if it works but you could try this:

Count =
var Count = CALCULATE(COUNT('Company data'[Secondary company]),ALLEXCEPT('Company data','Company data'[Secondary company]),'Company data'[Secondary company]=SELECTEDVALUE('Company data'[Main company]))
Return
IF(Count=Blank(),"NA",Count)

6 REPLIES 6
Post Patron

@jppv20 One more query sir. When I select a single company in slicer, it provides me the count of secondary comnpanies very well but when I select All option in the slicer, it throws (Blank) in the card visual where I used this measure. HOw to edit the measure so that it shows 'NA' when I select All option in slicer

Solution Sage

Not 100% sure if it works but you could try this:

Count =
var Count = CALCULATE(COUNT('Company data'[Secondary company]),ALLEXCEPT('Company data','Company data'[Secondary company]),'Company data'[Secondary company]=SELECTEDVALUE('Company data'[Main company]))
Return
IF(Count=Blank(),"NA",Count)

Solution Sage

Could you provide some example data?

Post Patron

Hi @jppv20 I can't uplod original data due to restrictions but pls see below example.

See below data. I have single table having two columns as below. I will create a slicer based on Main company column & when I select a company out of it, it should give me count of rows for the same company in column Secondary company.

If I select company A in slicer, the card visual will show count as 4.

If I select company B in slier, the card visual will show count as 2.

Table - Company data

Column - Main company

A

B

C

D

E

D

E

F

Table - Company data

Column - Secondary company

A

A

A

A

B

B

C

C

C

D

D

E

D

E

F

F

F

F

F

G

G

G

G

Solution Sage

Try this measure:

Count = CALCULATE(COUNT('Company data'[Secondary company]),ALLEXCEPT('Company data','Company data'[Secondary company]),'Company data'[Secondary company]=SELECTEDVALUE('Company data'[Main company]))

If I answered your question, please mark it as a solution to help other members find it more quickly.
Post Patron

@jppv20 You are Awesome. This is working. God bless you man.

Announcements