Measure value multiply numbers of selected column items

[thhmez7]

Hello,

I'd like to create a measure which dynamically changes whenever an item in a slicer is selected. The measure value should be mulitplied by the number of the selected items.

For example:

Measure: Points = SUM('Table'[points]) 

Current value of Points = 20

Field in Slicer: Username

Username contains 5 names (A, B, C, D, E)

When one name is selected, Points remain 20. When 2 names are selected, then 20 * 2 = 40.

3 names > 20 * 3 = 60 etc.

How can this measure be created?

Thank you.

[AntoineTRICHET · Accepted solution]

Hi @thhmez7 

You can use the following measure :
Points = COUNTDISTINCT([Username])*20

I hope it helped you

[AntoineTRICHET · Accepted solution]

Hi @thhmez7 

You can use the following measure :
Points = COUNTDISTINCT([Username])*20

I hope it helped you

[thhmez7 · Accepted solution]

Hi @AntoineTRICHET 

Countdistinct does not exist as DAX expression. 

Distinctcount also does not work in this case.

[AntoineTRICHET]

Hi @thhmez7 

Indeed it is dinstinctcount and not countdistinct. Can you provide a screenshot of your table (I do not understand why it is not working) ?

[thhmez7]

Thanks, I had to adjust the measure, it works fine now.