Home

Returning distinct count of filtered records

RodBass
Occasional Visitor

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)

RoleName.jpgExample

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

Any help would be greatly appreciated.

 

2 Replies

Hi,

 

Please check out this link.

 

Hope that helps

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.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies