Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Count Name with Certain Date

HI All, my table looks like this. i have no idea how to visualize the certain date with the trainer and course name. I tried it , and it counts all of the name in the same date in a row. 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. 

 

Your input is really much appreciated. 

I 

Custom Visuals

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi 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's avatar
      Chanleakna123
      Post Prodigy
      8 years ago

      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's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        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