cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Disregard first slicer after selecting the second slicer

Hi Guys, Im still getting used to DAX and im stuck. I need some help with my visual.

 

These are the columns i summed for my Visual.
SUM.png

 

These are the filters. And for each filter i select, i want the corresponding "Sum" formula to calculate for me.

Filters.png

 

This is what happens. After choosing my second slicer, the values tend to get wrong. Its supposed to have 85% saturation however with my calculation im getting a way smaller number.

Visual.png

 

This is the calculation i have...I've also tries using the "ALL" and "ALLEXCEPT" function but still didnt get it to work.

formula.png

 

Hope there is a way to do this and i look forward to your help.

 

Thank you all,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Disregard first slicer after selecting the second slicer

hi, @Anonymous 

Do you mean that you want to disregard first slicer after selecting the second slicer and disregard first and second slicer after selecting the third slicer?

If so, you must define which slicer is first, second, third in the formula in advance.

Try this formula

Measure = 
SWITCH (
    TRUE (),
        ISFILTERED ( 'Lista De actividades'[Rol] ), CALCULATE (
        SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ),
        ALL ( 'Lista De actividades'[Deparmento], 'Lista De actividades'[Sub-Deparmento] )
    ),
    ISFILTERED ( 'Lista De actividades'[Sub-Deparmento] ), CALCULATE ( SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ), ALL ( 'Lista De actividades'[Deparmento] ) ),
    ISFILTERED ( 'Lista De actividades'[Deparmento] ), CALCULATE ( SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ) ),
   
    
    BLANK ()
)

Best Regards,
Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Disregard first slicer after selecting the second slicer

hi, @Anonymous 

Do you mean that you want to disregard first slicer after selecting the second slicer and disregard first and second slicer after selecting the third slicer?

If so, you must define which slicer is first, second, third in the formula in advance.

Try this formula

Measure = 
SWITCH (
    TRUE (),
        ISFILTERED ( 'Lista De actividades'[Rol] ), CALCULATE (
        SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ),
        ALL ( 'Lista De actividades'[Deparmento], 'Lista De actividades'[Sub-Deparmento] )
    ),
    ISFILTERED ( 'Lista De actividades'[Sub-Deparmento] ), CALCULATE ( SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ), ALL ( 'Lista De actividades'[Deparmento] ) ),
    ISFILTERED ( 'Lista De actividades'[Deparmento] ), CALCULATE ( SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ) ),
   
    
    BLANK ()
)

Best Regards,
Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Re: Disregard first slicer after selecting the second slicer

Thank you so much Lin! it worked! 🙂

 

 


@v-lili6-msft wrote:

hi, @Anonymous 

Do you mean that you want to disregard first slicer after selecting the second slicer and disregard first and second slicer after selecting the third slicer?

If so, you must define which slicer is first, second, third in the formula in advance.

Try this formula

Measure = 
SWITCH (
    TRUE (),
        ISFILTERED ( 'Lista De actividades'[Rol] ), CALCULATE (
        SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ),
        ALL ( 'Lista De actividades'[Deparmento], 'Lista De actividades'[Sub-Deparmento] )
    ),
    ISFILTERED ( 'Lista De actividades'[Sub-Deparmento] ), CALCULATE ( SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ), ALL ( 'Lista De actividades'[Deparmento] ) ),
    ISFILTERED ( 'Lista De actividades'[Deparmento] ), CALCULATE ( SUM ( 'Lista De actividades'[Saturaction Actual Sub Dept] ) ),
   
    
    BLANK ()
)

Best Regards,
Lin

 

 


 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,471)