Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Overlap scenario

Hi All,   I have Employee name and project name against them. Then i created a measuer which tells the total count of Projects in which they are working.   Now i would like to get those emp...
Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi Anonymous 

     

    Add a caluclated column to identify Names which have more than 1 project:

    Project Count = 
VAR RowName = Table1[Name]
VAR ProjectCount = 
CALCULATE ( 
    DISTINCTCOUNT ( Table1[Project] ),
    FILTER ( 
        ALL ( Table1 ),
        Table1[Name] = RowName
    )
)
VAR Result = 
IF ( 
    ProjectCount > 1,
    "Y",
    "N"
)
RETURN Result

     

    You can then use this column as a visual level filter on your table visualisation to display only the Names with more than 1 project.

     

    The following measure will give you the number of Names with more than 1 project:

    More Than 1 Project = 
CALCULATE (
    DISTINCTCOUNT ( Table1[Name] ),
    Table1[Project Count] = "Y"
)

     

    Best regards,
    Martyn


    If I answered your question, please help others by accepting it as a solution.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi create simple measure

 

measure= count(table[Projects])

 

and drag emp name and measure in table visual and add measure into visual level filter and set it to "is greater than 1"

 

to get total employees having greater than 1

 

measure2=Sumx(table,if([measure]>1,1,0))

 

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

The below measure is not working as expected for me.

 

measure2=Sumx(table,if([measure]>1,1,0))

 

 

Thanks