Add total views and clicks counts for particular Advertise.

[ppatel91]

How can I add a total views and clicks counts for particular Advertise. We have advertise in form of link in database table and we are displaying those as images in power BI that is in attached pucture.I am trying to add how many views and clicks that perticular advertise has(Note: it's not static images. This Ads images changes if you filter data based on date or perticular company). Also, we have total views and total clicks count column in table too. In this image, eye icon indicates no of views and mouse icon indicates the number of clicks. Also, the star icon indicates the most clicked advertisement. Also, we have filter based on the date range. I have never done something like this before. Please help me achieve this.

[v-jingzhang]

Hi @ppatel91 

I'm not sure if I understant it correctly. If you have total views and total clicks count column in table too, you can create a column in the table or a measure to add both counts. 

New Column = 'tablename'[View Count] + 'tablename'[Click Count]

New Measure = sum('tablename'[View Count]) + sum('tablename'[Click Count])

Put Advertise column into a slicer to select a particular advertise and put above new column or measure into a visual to show the total value. Or put Advertise column and above new column (or measure) into the same visual (e.g. table visual) to show the total count of every advertise. Is this what you want?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[ppatel91]

Hello,

Thank you for your response. Here, I am not looking for total values of views+clicks but I want total clicks and total views with the icons for that perticular Ad as I you in see in my Ads image. Since Ads are in the form of URL and coming from the database I am not sure how can I accommodate those icons(eye. mouse, start etc...) with each ad. I have more than 50 unique ads.