Forum Discussion

average_joe's avatar
average_joe
Frequent Visitor
3 years ago
Solved

How Do I Calculate Total Capacity for Daily Visit Chart?

Hi, Fairly new PBI user and have only just started learning DAX so am very stuck on this question.  I've tried searching but couldn't find a similar post. I have 3 tables: A Visit table that has ...
Need Help
  • average_joe's avatar
    average_joe
    3 years ago

    For anyone interested, I solved my issue by simply changing the chart to a bar chart and adding a constant line equal to the desk count.  I placed a card visual that summed the number of desks on the report page and the figures matched no matter the time period I selected.

  • average_joe's avatar
    average_joe
    Frequent Visitor
    3 years ago

    Thanks for the info Greg_Deckler .  Perhaps I don't quite understand the functions but I can't figure out how that would work for me.

     

    If someone is selecting a date range in a slicer on the report, I don't understand how I can incorporate this in the tmpTable created in the examples you sent through.

     

    I've tried CALCULATE(SUM([DeskCount]), ALLEXCEPT('OfficeData','OfficeData[OfficeName])) but again, as soon as I place this on the chart then I'm seeing a variable line which is affected by whether or not staff from an office turn up to work that day.

     

    I'm really stuck on this one.