Forum Discussion
Overlap scenario
- 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 ResultYou 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.
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.
Hi MartynRamsden ,
For larger dataset it is taking more time than expected and performance of the dashboard is getting hit.
Is there any other way to do it?
Thanks