Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
indranil36
New Member

count each profile as 1 regardless of the number of stages they've gone through

I need help with a specific problem.  I am extracting data from a dynamic spreadsheet which gets regular feeds for updates and additions in terms of rows

I have three specific Columns –

 

  1. Name of the profile  
  2. Stage of Operation ( 6 Stages)
  3.  Number of profiles

 

Each profile goes through six different stages.  .. Whenever a profile enters a new stage of operation a new row gets generated against the same profile .

. Hence if we take the count of profiles using the column “ Number of Profiles”  - we get more than 1 count for one distinct profile name because he / she may have gone through different stages … Now for count of number of profiles , this should count as 1 ….

 

Please suggest a measure in DAX or Power query editor to hand the above scenario.

 

1 ACCEPTED SOLUTION
AnthonyJoseph
Resolver III
Resolver III

@indranil36 Not sure if I understand your question. If you want to count the user profile only once irrespective of the number of rows the user profile is present? If yes, then you can use DISTINCTCOUNT('column name') in DAX meausre. If your requirement is not this, then please can you provide more details and show some sample input and output?

View solution in original post

2 REPLIES 2
indranil36
New Member

Let me share with you some data, though the solution you gave might be of help. In the attached spreadsheet regardless of the status which might /might not change but gives rise to additional rows for the same profile for any work done related to a profile, my count of job openings should be considered as one if the " Job: Title" remains unchanged .. Need help on the DAX expression on the same  https://docs.google.com/spreadsheets/d/1PkBbJUzT3GWvofB66m0ivM6wAwGDE29P/edit?usp=sharing&ouid=10075... 

AnthonyJoseph
Resolver III
Resolver III

@indranil36 Not sure if I understand your question. If you want to count the user profile only once irrespective of the number of rows the user profile is present? If yes, then you can use DISTINCTCOUNT('column name') in DAX meausre. If your requirement is not this, then please can you provide more details and show some sample input and output?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors