Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Power BI Community,
I have two tables that I have taken from Zendesk. Tickets and Ticket Metrics. We have two Brands on Zendesk for two companies. The Tickets table includes the Brand ID. The Ticket Metrics do not. Using Power query I have filtered out the brand ID i do not want from the Ticket table. I then created a custom column on the Ticket Metrics table to look up the brand ID and report it back. This leaves me with rows of data that have a Brand ID of null. I want to filter these out so they are not in the table of data however when I go to Power Query the column is not there. I am assuming this is because it's a custom column so doesn't show in Power Query.
Is there any way of filtering out all of the rows without a Brand ID out of the data table other than Power Query? At the moment all of my measure have to have a line filtering out all of the tickets metrics without a brand ID but I am hoping there is a better way.
Thanks
Solved! Go to Solution.
@Rogerh , Not very clear but you can have filter at visual or page level brand id blank or not blank
@Rogerh , Not very clear but you can have filter at visual or page level brand id blank or not blank
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |