Forum Discussion

ajdm2007

Helper III

2 years ago

Solved

Adding previous month measure

Hi everyone, I have this visualization with several metrics. I’d like to add a metric to each card showing the value from the previous month. For example, if I'm viewing the data for August, I wa...

General Comment

Need Help

Tips and Tricks

lbendlin
2 years ago

Tickets Solved Previous Month.pbix35 KB

lbendlin

Super User

2 years ago

total_tickets_solved = 
COUNTROWS(
    FILTER(
        tickets,
        RELATED('status'[description]) = "Completed"
    )
)

RELATED has no place in a measure. The relationship is implied through the data model.

total_tickets_solved = 
CALCULATE(COUNTROWS(tickets),
    'status'[description] = "Completed"
)

In addition you should try and avoid filtering entire tables. Filter columns when possible.

ajdm2007

Helper III

2 years ago

This is my goal:

I have already the Total Tickets Solved one.

So, based on your last insight, what should the measure's formula be?

Thank you so much for your support.