Distinct Value with filter greater than >5

[Anonymous]

Hello all experts

I need create a measure in DAX which allow me to see the Disctinct Count for a table (Id Campione) and show me the Count of other column (Parameter) if this one has values greater than 5 (>5)

I put this example here: As you can see IdCampione has 3 count distinct for all the table.

And the Parameter has a count of 10 values. The logical needs to shows when the CountDistinct of IdCampione is >5 show me data in the table, and when this is not true, do not show anything.

So far I got this put wont work:

Contaminated Samples > 5 =

CALCULATE(

        DISTINCTCOUNT('Level2-AnalysisList2'[IdCampione (sampleList)]),

        FILTER ('Level2-AnalysisList2', 'Level2-AnalysisList2'[IdCampione (sampleList)] >5)

      )

Thanks for the help

[amitchandak]

@Anonymous , You need COUNT('Level2-AnalysisList2'[IdCampione (sampleList)]) > 5?

Create a measure

calculate(COUNT('Level2-AnalysisList2'[IdCampione (sampleList)]), filter(allselected('Level2-AnalysisList2') , 'Level2-AnalysisList2'[IdCampione (sampleList)]) = max('Level2-AnalysisList2'[IdCampione (sampleList)]) ) )

and use visual level filter measure > 5