Forum Discussion

RodBass's avatar
RodBass
Copper Contributor
Feb 19, 2019

Returning distinct count of filtered records

Here is my problem.

I have 2 columns (Rationale Documented & Role Name)

 

I need a formula that can filter the entire Rationale Documented column to identify when Rationale Documented > 0; then return a count of distinct Role Names found on the rows left in the filtered data.  I’ve tried all types of countif/countifs/sumx, etc… formulas.  But nothing I’ve come up with is getting me the result I need.

Using the example image, the result count I'm expecting will be 2. (FNC_ARASH_ARASH_ARASH_Performer_GO and FNC_IT_Christopher_Black_Team_Performer_GO)

Example

I also tried using DAX and creating a measure.  I'm open to whatever works.

Any help would be greatly appreciated.

 

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello

     

    Create a pivot table that is loaded into the data model and use the DistinctCount function.

     

    Or use Power Query to remove the duplicates in column "Role Name" and count the remaining items.

     

Resources