Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Userrelationship and date

Hello, I have a problem, I have a date table and another table with a date column and data, I try to use a date filter but when I change the date I do not display any value.

The measure I use is

Session A = CALCULATE(COUNT(Hoja1[Neighborhood]), USERELATIONSHIP('Period A'[Date], Hoja1[last_modified]))
Quantity = CALCULATE(COUNT(Hoja1[Neighborhood]))
Neighborhood = CALCULATE(VALUES(Hoja3[neighborhood]))
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, Syndicate_Admin 

    Very happy that you can solve this problem.

    According to my understanding, if we use a date table, then our dimensions generally need to place the fields in the date table, and then we can put the fields in our fact table if the values are valued.

    And for the date table, we need to activate the relationship to get the value of our fact table, if it is a dummy relationship then we need to use the DAX function to activate the relationship.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I forgot to mention that I would like to put a range of date but it does not show me anything when I move it

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Community Support
      3 years ago

      Hi, Syndicate_Admin 

      Very happy that you can solve this problem.

      According to my understanding, if we use a date table, then our dimensions generally need to place the fields in the date table, and then we can put the fields in our fact table if the values are valued.

      And for the date table, we need to activate the relationship to get the value of our fact table, if it is a dummy relationship then we need to use the DAX function to activate the relationship.

       

      Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

       

      Best Regards,

      Aniya Zhang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly