Forum Discussion
Simple table visualization using data from four related tables
Hi dougford99,
I've managed to create a list of class recommendations, but I can't figure out how to exclude a class if the employee has already attended it.
If I understand you correctly, you should be able to use the formula below to create new measure, then use it to apply a visual level filter(measure is 1) on Table visual of class recommendations list you have managed to create, to exclude a class if the employee has already attended it. :smileyhappy:
measure = VAR currentClass = MAX ( dmClassRecommendations[Clas] ) RETURN IF ( CONTAINS ( VALUES ( ftClassRegistration[Title] ), ftClassRegistration[Title], currentClass ), 1, 0 )Regards
Hi dougford99,
I've managed to create a list of class recommendations, but I can't figure out how to exclude a class if the employee has already attended it.
If I understand you correctly, you should be able to use the formula below to create new measure, then use it to apply a visual level filter(measure is 1) on Table visual of class recommendations list you have managed to create, to exclude a class if the employee has already attended it. :smileyhappy:
measure =
VAR currentClass =
MAX ( dmClassRecommendations[Clas] )
RETURN
IF (
CONTAINS (
VALUES ( ftClassRegistration[Title] ),
ftClassRegistration[Title], currentClass
),
1,
0
)
Regards
Very elegant solution, I'll need to remember that for future applications. Unfortunately, the visualization has multiple columns including the recommendation type (required, recommended, optional, etc.). If I display just the class title, the measure works perfectly. But if I add a second column to the visual the dataset increases. I'm happy to accept the solution since it does solve the issue if only one column of data is displayed in the visual. But I'd really appreciate any additional thoughts on how to resolve the issue when there is more than one column included in the table visual.
Thanks!
Doug
