Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
hi @KuntalSingh
You can created measure
Measure=Distinctcount(Selectedvalue(datecolumn))*1221
Thanks,
Thennarasu
Thank you very much for quick response
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
64 | |
45 | |
44 | |
40 |