Forum Discussion

vinayguptak81's avatar
vinayguptak81
Frequent Visitor
3 years ago

DAX Count not working

Hi everyone, I am running into an issue and need some guidance. Situation:  I have a handful of stores that I would like to count based on the Invoice Date selected, but excluded if they were close...
Wilson_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Vinay,

 

What does your data model look like?

vinayguptak81's avatar
vinayguptak81
Frequent Visitor
3 years ago

Hi Wilson,

Table 1 is detail and Table 2 is roll-up.  The relationship between the two tables is Entity join.

  • Wilson_'s avatar
    Wilson_
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Vinay,

     

    It sounds like at the very least you would benefit from a dates/calendar table (and perhaps from an entity dimension table). Not the quick fix you were perhaps looking for but it soudns like you would benefit long term from learning about data modeling; a proper data model would make this easier to build than having to overcomplicate the DAX. SQLBI is a phenomenal resource and they have a free intro to data modeling course available.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

    • vinayguptak81's avatar
      vinayguptak81
      Frequent Visitor
      3 years ago

      Hi Wilson,

      Thanks for the suggestion. I'll take a look at it.