Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ALLSELECTED - ALL - ALLEXCEPT Confusion

Hi All,   I'm really sorry for that. There was tons of article on web about this topic but I'm still confused.   Please help me ! I have a table as below.  I have a value it depends on Custome...
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    It sounds like you want to remove the filters from both your Shop and Customer columns.  This measure should do that.  It is a small change from the previous proposed solution.

     

    Total Value = CALCULATE(SUM(ZV_CRM03_Q010[Value]),ALL(ZV_CRM03_Q010[Shop], ZV_CRM03_Q010[Customer]))

     

    Regards,

    Pat

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

Your data model is not clear but maybe it will help

Total Value = CALCULATE(SUM(ZV_CRM03_Q010[Value]),ALL(ZV_CRM03_Q010[Shop]))

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38 
I have only one table named as ZV_CRM03_Q010

 

I tried your solution. it is returning correct values on table but when I make filtering on Shop it is returning false values.

I want to show same values for customers on second image.

 

  • hohlick's avatar
    hohlick
    Icon for Continued Contributor rankContinued Contributor
    6 years ago

    Hi Anonymous 

    Try this

    =
    SUMX(
        ALL( 'ZV_CRM03_Q010'[Shop] );
        CALCULATE(
            SUM( 'ZV_CRM03_Q010'[Value] )
        )
    )

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi hohlick,

       

      I tried your formula but it isnt't working.

       

      It is returning same value for all rows.

       

      • mahoneypat's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee
        6 years ago

        It sounds like you want to remove the filters from both your Shop and Customer columns.  This measure should do that.  It is a small change from the previous proposed solution.

         

        Total Value = CALCULATE(SUM(ZV_CRM03_Q010[Value]),ALL(ZV_CRM03_Q010[Shop], ZV_CRM03_Q010[Customer]))

         

        Regards,

        Pat