Forum Discussion
Post ProdigyCount Name with Certain Date
Community SupportHi Chanleakna123,
I can't understand your requirement very well. Comparing this paragraph
"What i want is to count only that 1 trainer's name with Certain Date on day 20. therefore , when i do visulization , it will count How many time trainer train the most during this month .
for ex : Mr. Yun Min Chia Trained on 20 Mar for 1 time. and Yun virakrith train on 24 and 25 for 2 times. "
with screenshot, there are records for day 20 only in month March and the Trainer "Yon Virakrith" has one course on 2/27/2018. So can you clarify the bold section above?
Please show some sample data and clarify corresponding desired results.
Best Regards,
Qiuyun Yu
- Chanleakna123
v-qiuyu-msft sorry , i stated the wrong name .
Yes Mr. Yon Virakrith only 1 time on 27/02/2017 and Yun Min Chia train on 20 is 1 time being a trainer.
So the visualization should be , on 20 of Mr. Vankatesh is 1time and on 27 of Mr. Yun Virakrith is also 1 time for being a trainers and Mr. VenKatesh on 22 23 24 25 is 4 times of being trainers
But what i'm seeing on my report is count all of his name on only date : for ex , On 20 , Mr. Yun Min Cha trainer for 9times.Mr. Yon Virakrith is 1 time ( Correct ) , Mr. Vankatesh , trainers for 2 times on 25 , 24 for 3 times ....
So i don't want my report to count him on the same date like this , must be count only the certain date with 1 , for Ex : Mr. Vankatesh is a trainer on 25th Counted 1 , is a trainer on 24th Counted 1 , Trainers on 23rd Count 1 ....- v-qiuyu-msft
Hi Chanleakna123,
You can create a measure:
Measure 2 = CALCULATE(DISTINCTCOUNT('Table'[Trainer]),FILTER(ALLSELECTED('Table'),'Table'[Date]=MAX('Table'[Date])))
Best Regards,
Qiuyun Yu
