Hiding visuals if number of rows selected < certain amount and display alternative message

[po]

Hi,

We have a report whereby users can select certain values in slicers and if number of rows < certain amont we don't want the results to be displayed and instead display a different message - this is in order to preserve anonymity.

How can this be best achieved? 

Alternatively if have column in table and when selected rows < certain value how can this best be achieved.

Tried 

if(DISTINCTCOUNT('table'[col])<10,"anon",MAXX('table','table'[col])) but dosen;t seem to work, similary with calculated column

Thanks

[v-jayw-msft]

Hi @po ,

Try:

Measure = IF(CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'))<10,"anno",MAXX(ALLSELECTED('Table'),'Table'[col]))

Best Regards,

Jay

[amitchandak]

@po , Try a meausre like

measure =
var _cnt = calculate(DISTINCTCOUNT('table'[col]), allselected('table'))
return
if(_cnt<10,blank(),MAXX('table','table'[col]))

[po]

Thanks for info

[po]

Thanks for info