Month over Month visual not Totaling

[BlackCat]

@Pragati11 

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?

[Icey]

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.

[Pragati11]

Hi @BlackCat ,

Is this something you are looking for?

[Pragati11]

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: