Forum Discussion

fenixen's avatar
fenixen
Icon for Advocate II rankAdvocate II
9 years ago

Count items in a given datetime interval across several days

  I want a chart that shows number of agreements per day (no problem), but i want to be able to drill down to hours and still get the correct count.    I have a Calendar table connected to the fac...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi fenixen,

Congratulations. You have resolved your issue. Thanks for your sharing solution, please mark your reply as answer, which will help others to find workaround easily.


Thanks,
Angelia

fenixen's avatar
fenixen
Icon for Advocate II rankAdvocate II
9 years ago

Hi v-huizhn-msft

 

Well I wish I had solved it.. problem is that it doesn't work when i remove the AgreementID from the matrix or the graph. 

As you can see the graph looks terrible, the customer cannot use it with agreementID on the legend :( 

 

Really annoying that I can't solve this.. I've seen so much magic in dax, I would think it should be solvable :)