@Jagadish_Prasad
Certainly! Here’s the revised approach with additional spacing:
1. Create a Dynamic Filter Measure:
Develop a DAX measure that will manage the filtering based on the selected Production Role. This measure will determine whether to display rows in your report depending on whether the 'Intern' role contains null values.
```DAX
Role Filter =
VAR SelectedRole = SELECTEDVALUE('Assignment'[Production Role])
RETURN
IF(
SelectedRole = "Intern",
IF(
ISBLANK('Assignment'[Intern Name]),
BLANK(),
1
),
1
)
```
This measure checks if the selected role is "Intern" and if the 'Intern Name' is blank. If both conditions are met, it filters out the row by returning BLANK(); otherwise, it keeps the row.
2. Apply the Measure in Your Visuals:
Place the "Role Filter" measure as a filter in your table and card visuals. Set this filter to show items when the value is 1. This configuration will hide rows for null 'Intern' names when "Intern" is selected and will not affect the display of other roles.
3. Test the Setup:
After implementing the measure, test your dashboard by selecting different roles from your field parameter slicer. This will help ensure that the table and cards are responding correctly to the role selection, particularly filtering out the assignments without an 'Intern' only when that role is selected.
This approach will help maintain the dynamic and interactive quality of your dashboard, ensuring data is displayed appropriately based on user-selected criteria. If you encounter any issues or have additional requests, feel free to reach out for more assistance!
