Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculate same value but in different dates

Hello everyone,

 

Thank you for reading my query. Currently, I'm counting the location of event launching by different date but my DAX is always counted only unique location name instead of diffrent date as you can see the image below. You will notice that there is one location which had event in 2 dates, but my DAX still count only 4 instead of 5

This is my DAX, my table Date also has Start and End Date columns.

And this is my wish outcome: It will count as 5 if the location has diffrent event's date.

 

I hope you can help me to solve my problem. Thank you again so much.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello amitchandak ,

       

      I attached the table below for you to refer. Assume we will count the event type (Column C) is Group Detail (F2F) with HCO (Column B) in different date (Column A). For example, HCO 4 will be count as 4 following by different dates. Thank you.

       

      Date               HCO        Event Type

      01/07/2022HCO 1Detail (F2F)
      02/07/2022HCO 2Detail (F2F)
      03/07/2022HCO 3Detail (F2F)
      04/07/2022HCO 4Group Detail (F2F)
      05/07/2022HCO 5Group Detail (F2F)
      06/07/2022HCO 6Detail (F2F)
      07/07/2022HCO 7Detail (F2F)
      08/07/2022HCO 8Detail (F2F)
      09/07/2022HCO 9Detail (F2F)
      10/07/2022HCO 10Group Detail (F2F)
      11/07/2022HCO 4Group Detail (F2F)
      12/07/2022HCO 5Group Detail (F2F)
      13/07/2022HCO 4Group Detail (F2F)
      14/07/2022HCO 4Group Detail (F2F)
      15/07/2022HCO 5Group Detail (F2F)
      16/07/2022HCO 16Remote Detail
      17/07/2022HCO 17Detail (F2F)
      18/07/2022HCO 18Detail (F2F)
      19/07/2022HCO 19Detail (F2F)

       

       

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        Anonymous , I think I am still not clear of that

         

        Try like

         

        countx(filter(Table, Table[Event Type] = "Group Detail (F2F)" ) , [Date])