Power BI - Measure where all filters but one persist / ignore filter by a certain column

Question

I am having a table and I want to allow the reports to the manger to report and count the machines according to softwares selected in the tables

So,I want to a measure which sets a filter by igoring a certain column How can I do this?

Answer 1

Use the following measure:

Total Asset Count = Calculate(DistinctCount('HW'[PCName]),ALL(HW[Software]))

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification