DAX not working

Anees91 ,

The issue you’re encountering arises from the filter context when interacting with multiple visuals, particularly the bar chart and the gauge visual, combined with the date slicer. The discrepancy occurs because your Service Success measure uses ALLSELECTED and REMOVEFILTERS, which can sometimes reset or alter the filter context unexpectedly.

To address this, you can refine your measure to ensure consistent behavior across all visuals. Modify the measure as follows:

Service Success =
VAR Numerator = CALCULATE(
    COUNT('Volume'[Failure.ConsignmentId]),
    REMOVEFILTERS('Volume'[Failure.SFCCode]) 
)
VAR Denominator = CALCULATE(
    COUNT('Volume'[ConsignmentId]),
    REMOVEFILTERS('Volume'[Failure.SFCCode]) 
)
RETURN
IF(
    Denominator = 0,
    BLANK(),
    1 - (Numerator / Denominator)
)

This updated formula ensures that the SFCCode filter is removed consistently, allowing the measure to correctly calculate percentages even when interacting with slicers or visuals. Additionally, verify that the date slicer’s filtering context is applied correctly to the visuals by reviewing the relationships between your date column and the Volume table.

Make sure the interactions between the visuals are properly configured in Power BI. Check that the bar chart filters the gauge visual as intended while the date slicer applies to both the bar chart and the gauge visual. You can do this by going into "Edit Interactions" and adjusting the behavior to suit your needs.

If the problem persists, you can experiment with removing REMOVEFILTERS in the measure to see if it resolves the issue. Testing the gauge visual with and without slicer interaction can help pinpoint where the filter context is being lost. Additionally, using the Performance Analyzer in Power BI can provide insight into how the filter context is being applied during interactions. This will help ensure that all visuals are synchronized and displaying the correct calculations.

Best regards,

Thank you for replying, I have tried them to no success, I've even tried this where I would specify on a different column instead : 

Hello Anees91,

Can you please try this approach:

Service Success =
1 - DIVIDE(
    COUNT('Volume'[Failure.ConsignmentId]),
    CALCULATE(
        COUNT('Volume'[ConsignmentId]),
        REMOVEFILTERS('Volume'[Failure.SFCCode]),
        ALLSELECTED('Volume')
    )
)

Hi Anees91 

Try adjusting the formula for Service Success to use ALL instead of ALLSELECTED for the gauge visual calculation, so that the slicer context does not affect it, while still respecting the selection made in the bar chart:

Service Success =
VAR Numerator = CALCULATE(COUNT('Volume'[Failure.ConsignmentId]))
VAR Denominator = 
    CALCULATE(
        COUNT(Volume[ConsignmentId]),
        REMOVEFILTERS(Volume[Failure.SFCCode]),
        KEEPFILTERS(ALLSELECTED(Volume[Failure.SFCCode]))   // Keeps filter for failure codes
    )
VAR DenominatorGauge = 
    CALCULATE(
        COUNT(Volume[ConsignmentId]),
        REMOVEFILTERS(Volume[Failure.SFCCode]),
        ALL(Volume[Date])  // Removes the date slicer filter context for gauge visual
    )
RETURN
IF(
    Denominator = 0,
    BLANK(),
    1 - (Numerator / Denominator)
)

Please consider:

• If you are using multiple slicers or complex filtering, ensure that the right context is applied for both your chart and gauge visual.
• You may also need to check the interactions between the visuals to ensure the slicer and filters are behaving as expected (especially for the gauge visual).

This approach should resolve the issue with the gauge visual not updating correctly when clicking on failure codes in the bar chart while still respecting the slicer for the combo chart.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

Hi Anees91 ,

Consider using summarize to create a Code's dimension table and then filter it. Try to share some sample data along with expected results.

Best regards,
Community Support Team_ Scott Chang