Forum Discussion

KuntalSingh's avatar
KuntalSingh
Helper V
3 years ago
Solved

Need help on measure

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    KuntalSingh , You can use a measure like

     

    distinctcount(date[Date])*1221

Thennarasu_R's avatar
Thennarasu_R
Responsive Resident
3 years ago

hi KuntalSingh 

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

Thanks,
Thennarasu

KuntalSingh's avatar
KuntalSingh
Helper V
3 years ago

Thank you very much for quick response