How to get count based on the the filter selected.

[Anonymous]

Hi Guys,

Can you please help me how i will get the count based on the filter selected. I have month data like 1,2,3,4,5
if i select all it should give me result as "5" else based on the numbers of month selected it should give. 

If in filter, i have selected 1,4,5 then i am expecting result as 3. Please help me how i can achieve this based on the filter selection it should get me the result.  

Thanks.

[amitchandak]

@Anonymous , simple count should work in that case

COUNT('Table'[Month])

[Anonymous]

@amitchandak No it's giving the count of rows for each month. Let me explain once again as i told based on the month selected it should give the result. Only 5 output i am expecting the result based on the month selected like if only 1 month selected than 1,

if 2 selecected than 2

if 3 selecected than 3

if 4 selecected than 4

if 5 selecected than 5

please do let me know how it can be acheived. 

[sturlaws]

Hi @Anonymous 

can you try this:

Number of selected months = CALCULATE(distinctcount('Table'[Month]))

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[Anonymous]

No it's giving the count of rows for each month. Let me explain once again as i told based on the month selected it should give the result. Only 5 output i am expecting the result based on the month selected like if only 1 month selected than 1,

if 2 selecected than 2

if 3 selecected than 3

if 4 selecected than 4

if 5 selecected than 5

please do let me know how it can be acheived. 

[danielkrol]

Create a measure like this?

NoSelected = CALCULATE(COUNT('Yourtable'[columnName]))

where "Yourtable" is the table of your slicer and "columName" the column of the slicer.

[Anonymous]

No it's giving the count of rows for each month. Let me explain once again as i told based on the month selected it should give the result. Only 5 output i am expecting the result based on the month selected like if only 1 month selected than 1,

if 2 selecected than 2

if 3 selecected than 3

if 4 selecected than 4

if 5 selecected than 5

please do let me know how it can be acheived.