Don't display the data in card visual when more than one filter value is selected

[vinothkumar1990]

Hi,

 I have a client requirement. When a filter selected with more than one value then card visual should not display any data.

For example In the below model, If only one Month(i.e. January 2020) is selected then card visual should be displayed otherwise it should not display any data.

Note: All the filters should be in filter pane only.

Can you plese help me out?

[amitchandak · Accepted solution]

@vinothkumar1990 , isfiltered and hasonevalue can help

measure =

var _cnt = calculate(distinctcount(Table[Month year]), allselected(Table))

return

if(isfiltered (Table[Month year] ) && _cnt >1 , blank(), [measure])

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[v-xiaotang · Accepted solution]

Hi @vinothkumar1990 

I create a sample, and you can try like this.

Measure = 
var _count=CALCULATE(DISTINCTCOUNT(ProductDetails[brand]),ALLSELECTED(ProductDetails))
return
IF(_count<>1,BLANK(),"measure")

result:

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@vinothkumar1990 , isfiltered and hasonevalue can help

measure =

var _cnt = calculate(distinctcount(Table[Month year]), allselected(Table))

return

if(isfiltered (Table[Month year] ) && _cnt >1 , blank(), [measure])

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[vinothkumar1990]

@amitchandak - Thanks for the help!

it worked when more than months are selected, but fails when nothing is selected or all are selected