When Using Group By In Powerbi Desktop Column Value Is Not Active

In my data set, each PolicyNumber can have multiple ClaimNumber. So all I want to do is to get Unique PolicyNumber and Count the number of Claims (ClaimNumber) for each PolicyNumbe

Solution 1:

When counting rows it does not matter which column you count against, which is why Power BI doesn't populate the drop down.

The Group By dialog does not support distinct column counts (as for April 2017).

Instead, you can add a measure to your data model, using DAX, that returns a distinct count.

=DISTINCTCOUNT([ClaimNumber])

Or you can create a 2nd table, that sits on top of the first, which contains only unique combinations of PolicyNumber and ClaimNumber. You could then group by PolicyNumber and count the rows, which would return the distinct claim count.