Need help on measure

[KuntalSingh]

Hi All,

I have a 'Rolling Calender'[Dates] table and other table is 'User_Master'[User Target]. User daily target is 1221. If i want to selecte one date from slicer then it will show 1221 as target in Gauge graph if I select 2 dates then it will show 1221*2 and so on . Number of dates selected from the slicer it will * the target by 1221.

Can you please help and suggest the function 

[Thennarasu_R]

hi @KuntalSingh 

You can created measure
Measure=Distinctcount(Selectedvalue(datecolumn))*1221

Thanks,
Thennarasu

[KuntalSingh]

Thank you very much for quick response

[amitchandak · Accepted solution]

@KuntalSingh , You can use a measure like

distinctcount(date[Date])*1221