Forum Discussion
Helper IITable Visual- How to filter 2 identical columns with 2 separate filters
Instead of having your 'Count of Notifications' column in your data you need to create two measures. One which returns the number of tickets in last 30 days, the other will show the last year's count of tickets. Then place them both inside your table.
If you would like help with the dax here's how i'd write them (I don't know your tables/data, so you will have to fill this in. If you'd like me to do it for you then screenshot your data column names and i'll put them in for ya.Tickets in Last 30 Days =
CALCULATE(
COUNTROWS(Tickets),
FILTER(
Tickets,
Tickets[DateReceived] >= TODAY() - 30 && Tickets[DateReceived] <= TODAY()
)
)Tickets in Last Year =
CALCULATE(
COUNTROWS(Tickets),
FILTER(
Tickets,
Tickets[DateReceived] >= TODAY() - 365 && Tickets[DateReceived] <= TODAY()
)
)
Instead of having your 'Count of Notifications' column in your data you need to create two measures. One which returns the number of tickets in last 30 days, the other will show the last year's count of tickets. Then place them both inside your table.
If you would like help with the dax here's how i'd write them (I don't know your tables/data, so you will have to fill this in. If you'd like me to do it for you then screenshot your data column names and i'll put them in for ya.
Tickets in Last 30 Days =
CALCULATE(
COUNTROWS(Tickets),
FILTER(
Tickets,
Tickets[DateReceived] >= TODAY() - 30 && Tickets[DateReceived] <= TODAY()
)
)
Tickets in Last Year =
CALCULATE(
COUNTROWS(Tickets),
FILTER(
Tickets,
Tickets[DateReceived] >= TODAY() - 365 && Tickets[DateReceived] <= TODAY()
)
)
wiselyman3That worked perfectly, thank you!! I am new with powerbi and this was a light bulb moment for me, haha. I apprecoate the help
No problem! Welcome to the BI community, good luck with your report!
Did this fix the issue? 🙂 If so please mark as solution, would really help me out! If it didn't, we can try again!