Forum Discussion
Solved
DISTINCT COUNTROW based on value
Hi, New PBI user here. I have a list of SITE URLs, assigned to parts of the company. I need to present where the ownership is missing. Example data to ilustrate: Site Collection URL Area ...
Measure = CALCULATE(DISTINCTCOUNT(Sites[Site Collection URL]), Sites[Owner Status] = "Owner Missing")
You can show a percentage if you select 'show value as-> percent of grand total' from the dropdown in the Values field well.
