Forum Discussion
Solved
Table visualization & Hyperlinks
Hey, I am pretty new to PowerBI and I am using this also as a platform to learn, so I hope you dont mind me asking seemingly basic questions. I have an excel table with ticket numbers which I can...
Thanks. I guess this solves my 2nd question, however I am not sure about number 1.
Based on my large table with ticket#, I created a measure which provides the count of open tickets for the current week.
_openTicketsCurrentWeek =
VAR _cDate = TODAY()
RETURN
CALCULATE(
DISTINCTCOUNT('Aspen Tickets'[Number]),
FILTER(
'Aspen Tickets',
'Aspen Tickets'[Created(opened_at)] <= _cDate
&& ('Aspen Tickets'[Closed]) > _cDate || ISBLANK('Aspen Tickets'[Closed])
)
)
What I would like to do now is take the ticketIDs from this result and put them into a table visualization. I guess it's super simple, but as mentioned, I am a beginner.
Thanks
Screenshot attached shows a snapshot of my input data.
On my PBI dashboard, I will depict a card with the number of currently open tickets.
I also want to have a table below that card which shows a list or table of the "INC" numbers which are currently open.
Somehow like this:
However here, I just pulled the "Number" attribute into the table which then gives me ALL ticketIDs in my table unfiltered.