CODEWITHSUNDEEP
filteringpowerbi
Dick Rosenberg
Dick Rosenberg

Reputation: 113

Power BI - How do I put a filter on a card visual based on the value in another column

I am brand new to Power BI. I have detail data that looks like

Server Application Server1 App1 Server1 App2 Server2 App1 Server2 App3

My manager wants to get some analytics. The first was Distinct # of Servers. I was able to do this with a card Visualization.

The second is # of Apps using more than 1 processor. I am able to make a Card Visualization of the # of Distinct Apps and I can use Server as a filter, but the only options I have are that the Server is one of the Servers in the data or if I use Advanced Filtering it only has text options like Contains, Does Not Contain, etc. There are no count options available. How can I accomplish this seemingly simple task?

Thanks,

Dick

Upvotes: 0

Views: 8402

Answers (1)

Nelson Gomes Matias
Nelson Gomes Matias

Reputation: 1997

If I understand well your problem you can proceed like this: Table containing data

You should build a measure like that: CountOfApp = COUNT(Table1[Application])

then you can use it to filter servers with more than x application like this: See Visual level filters on the selected visual

Hope that helps!

Upvotes: 1

Related Questions