Forum Discussion
Issue with time intelligence and Quick Measure
Hi Anonymous ,
In my opinion, it is not normal for the Total MoM to be 0%. I did some test of using your formula and the result looks normal：
I think there might be something wrong in other place. Could you please share your pbix to me if you don't have any Confidential Information?
BTW, here's my pbix for your reference. Hopefully works for you.Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
In my opinion, it is not normal for the Total MoM to be 0%. I did some test of using your formula and the result looks normal：
I think there might be something wrong in other place. Could you please share your pbix to me if you don't have any Confidential Information?
BTW, here's my pbix for your reference. Hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Thanks for your answer. what is different on your solution is you created the measure in Calendar and use it to creare the MoM. I created a measure under File for ID. So, I went ahead and use your path but for some reasons I still got 0.00% . I have attached the link for the pbix. hopefull, you can access it. https://drive.google.com/file/d/1WVLcCt8EQJbn2ZvPlSBGKwpgHgS4ZbqF/view?usp=sharing
in case you can't access the link, here is the link for the data sample
https://drive.google.com/file/d/1nlTpu2vU9xbzme8lfjlptU278RyhYEoM/view?usp=sharing
Thanks for your help and feedback.