Need to show count of filtered items and count of total items

[bvilten]

Thanks for taking the time to read this, I appreciate it.

I am trying to do something I thought would be relatively easy. I am trying to replicate an excel sheet in PBI. The first image is the spreadsheet and the second is the matrix view within PBI.

The problem is that I cannot figur out how to display the total tickets created and percentage of tickets lines in Power BI.

Any help would be appreciated.

Excel VersionPower BI Version

[bvilten]

Hello, I have part of the solution. I was not using the grouping capabilities of PBI correctly. I now have the counts that I need. Total Password Resets, Total Other, Total Tickets. So now what I am looking for is DAX for generating a Measure the percentage of Total Tickets that is Total Password Resets. And a way to display that percentage. Though I am working on putting the DAX into a tool tip report assuming I can figure out the DAX. Thank you

[nirvana_moksh]

@bvilten what is the math behind 'Total Tickets Created'?

[bvilten]

This is what I want to do: count of filtered items + count of other items = total items then (count of filtered items / total items) * 100

[v-frfei-msft]

Hi @bvilten,

Based on my test, we cannot add rows in matrix by the way as in excel. Here we can create another table visual to work around.

Regards,

Frank