Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
You wrote:
But I can't see your calculation chnaging month-wise in the matrix visual that you have created.
The reason is the MONTH-YEAR column in this visual comes from a different table which hasn't got any relationship with your DEAL table.
Check this at your end. You will understand what I am trying to say.
Because this is a weighted measurement, the month over month doesn't change. How would I fix the relationship?
Hi @BlackCat ,
What kind of results are you expecting? Could you show me more details?
Reference: How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @BlackCat ,
Not sure what you are saying here.
If month-over-month figure won't chnage, then what is the reason of showing MONTH-YEAR in the matrix visual?
regarding relationship, you will have to create relationship between the tables highlighted below if you want your figures to chnage month-over-month:
User | Count |
---|---|
114 | |
107 | |
103 | |
57 | |
36 |
User | Count |
---|---|
149 | |
136 | |
101 | |
91 | |
62 |