Matrix creating multiple period when new measure is inserted

Hi Anonymous ,

Please try below steps:

1. Review Slicer Configuration: Ensure that your slicer is correctly configured to filter by the period you're interested in (FY24: P01). It's important to verify that the slicer is connected to the correct field and that it's indeed filtering the data as expected.

2. Check the Measure Logic: Review the logic within your DIFF_HOURS measure, especially how it interacts with the slicer's selection. Since your measure uses SELECTEDVALUE to determine the location and then applies logic based on that selection, ensure that the measure is correctly recalculating based on the slicer's filter. It might be helpful to test the measure's output by manually setting the location values to see if the expected results are returned.

3. Examine Matrix Visual-Level Filters: If your matrix visual is showing all years despite the slicer filter, it's possible that there might be an issue with how the visual-level filters are applied. Remember, visual-level filters will only affect the data displayed within that specific visual and not the slicer's operation itself.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.