Forum Discussion

Falongi_82's avatar
Falongi_82
Icon for Helper I rankHelper I
4 years ago
Solved

Help on Measure with ALLEXCEPT / ALLSELECTED - I'm LOST

Hi All,

 

I'm facing to one problem with my following measure that works properly when I don't use my slicer carrier.

Some capture to explain

-------------

In this case, my column '%' works perfect and values are ok.

 

But if I chose in my filter Slicer CARRIER, a value ==> the result of my column does not show my expected values on 100% by  picking date

Show my capture - filtered on BPOST:

 

Here my actual measure :

 

M_PARCELS_% = 
VAR val1 = CALCULATE([M_PARCELS],ALLEXCEPT(Q_BPOST_SLA_DAILY,Q_BPOST_SLA_DAILY[PICKING_DATE]))
--VAR val1 = CALCULATE([M_PARCELS];ALLSELECTED(Q_BPOST_SLA_DAILY))
VAR val2 = [M_PARCELS]
RETURN
DIVIDE(val2,val1,0)

 

I've made tests with allselected and .... but I can't get my result.

 

Thx in advance for your help and explaination

R/

Fabrizio

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Falongi_82 ,

     

    Please try the measure.

     

    M_PARCELS_% = 
VAR val1 =
    CALCULATE (
        [M_PARCELS],
        VALUES ( Q_BPOST_SLA_DAILY[PICKING_DATE] ),
        ALLSELECTED ( Q_BPOST_SLA_DAILY )
    )
VAR val2 = [M_PARCELS]
RETURN
    DIVIDE ( val2, val1, 0 )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Falongi_82 ,

     

    Please try the measure.

     

    M_PARCELS_% = 
VAR val1 =
    CALCULATE (
        [M_PARCELS],
        VALUES ( Q_BPOST_SLA_DAILY[PICKING_DATE] ),
        ALLSELECTED ( Q_BPOST_SLA_DAILY )
    )
VAR val2 = [M_PARCELS]
RETURN
    DIVIDE ( val2, val1, 0 )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • rodrigosan's avatar
    rodrigosan
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Hello
    Attempts to use the REMOVEFILTERS applied to your CARRIER field used in the checkbox.