Forum Discussion

FlankyPank2___'s avatar
FlankyPank2___
Icon for Helper I rankHelper I
2 years ago
Solved

Creating a relationship on my daily occupancy chart

Hi   I've produced a chart plotting daily occupancy (From wonderful support on here!).   The info comes from a spreadsheet called "Data" in a format like:   ID Number    Name                 Pr...
Need Help
  • FlankyPank2___'s avatar
    FlankyPank2___
    2 years ago

    Thank you for the reply.

     

    I'm just trying to track/count daily building residency.  Swapping between certain critera.  Using an active spreadsheet that uses a start & end date.  

     

    I followed a youtube tutorial

     https://youtu.be/O653vwLTUzM

    which gave me the total Value measure - i'll return to it and check.  Although at the time I double checked against an excel version I have and it seemed to match.

     

    I tried modifying the Total Value measure initially, but failed!

     

    I think i need to concentrate on learning more dax instead of winging it lol.

     

    Thanks 

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Got the pbix, thanks.

You are using a disconnected date table so that you can use Fact data between the start date and end date.

The card won't respond to changes in the date slicer because there is no relationship between the 2 tables.

You'll need to write a measure similar to the Total Value measure for this

---

However, are you happy with the Total Value measure? To me (and I don't know your business requirements) the date comparisons don't look correct.

max('Date23-24'[Date]) is the max value from the date slicer. You don't seem to be using the min value at all.

FlankyPank2___'s avatar
FlankyPank2___
Icon for Helper I rankHelper I
2 years ago

Thank you for the reply.

 

I'm just trying to track/count daily building residency.  Swapping between certain critera.  Using an active spreadsheet that uses a start & end date.  

 

I followed a youtube tutorial

 https://youtu.be/O653vwLTUzM

which gave me the total Value measure - i'll return to it and check.  Although at the time I double checked against an excel version I have and it seemed to match.

 

I tried modifying the Total Value measure initially, but failed!

 

I think i need to concentrate on learning more dax instead of winging it lol.

 

Thanks 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, FlankyPank2___ 

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

     

    Best Regards

    Yongkang Hua

    • FlankyPank2___'s avatar
      FlankyPank2___
      Icon for Helper I rankHelper I
      1 year ago

      Hi This problem wasnt' solved unfortuanately - I've tried to alter my Total Value Dax but i cna't see the wood for the trees.  I don't know if anyone can shed any light?

       

      It's a disconnected table so I know that's where the challenge lies - Thanks