Forum Discussion

FormworkFan's avatar
FormworkFan
Helper I
1 year ago
Solved

Calculate Function and Slicers

I have created a measure to provide sales from only 1 Key account.  These Key accounts in my data are all listed under my key accounts "National Accounts".   Key Account Sales = (CALCULATE([Total ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi FormworkFan 

     

    Congratulations! It seems that you have gotten a solution. Could you please share your solution and mark it as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

     

    Best Regards    

    Zhengdong Xu

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

  • FormworkFan's avatar
    FormworkFan
    1 year ago

     

     

    So it was pretty basic. I only had to enter in the Filter Context that I wanted to inlcude in my measure.

     

    Key Account Sales = (CALCULATE([Total Sales],'All Divisions Table-RS'[Customer] = "CONSTRUCTION PRODUCTS INC (ST)") , Region[Region] = "Key Accounts")

     

    So that worked, however when I now try to add this measure to my Total Sales measure, i'm getting a circular dependency error. I'm trying to sort that part out now.

     

     

FormworkFan's avatar
FormworkFan
Helper I
1 year ago

I figured this out! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi FormworkFan 

     

    Congratulations! It seems that you have gotten a solution. Could you please share your solution and mark it as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

     

    Best Regards    

    Zhengdong Xu

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

    • FormworkFan's avatar
      FormworkFan
      Helper I
      1 year ago

       

       

      So it was pretty basic. I only had to enter in the Filter Context that I wanted to inlcude in my measure.

       

      Key Account Sales = (CALCULATE([Total Sales],'All Divisions Table-RS'[Customer] = "CONSTRUCTION PRODUCTS INC (ST)") , Region[Region] = "Key Accounts")

       

      So that worked, however when I now try to add this measure to my Total Sales measure, i'm getting a circular dependency error. I'm trying to sort that part out now.