Forum Discussion

ajaydavidluke's avatar
ajaydavidluke
Helper I
3 years ago

Turnover Groups

Good afternoon Community,    I have a connundrum that I wanted some help with 🙂    I have a simple list of turnover by account 2022.  What I would like to do is  create a measure that sums the t...
saravanan_p's avatar
saravanan_p
Resolver III
3 years ago

Hi,

Thats perfect. And your results are correct. I see different color in maps. Check deeply, you see legends with different colors, but data is more for blue. You can obserev 1 or 2 orange color spots too. So its working. 
Kindly mark as solution , as this would support our community. 

ajaydavidluke's avatar
ajaydavidluke
Helper I
3 years ago

The issue I can see is that I have accounts with large turnovers but this group is no where to be seen, for example the biggest account is >750,000 but this isnt reflected in the map, ideally I would want only one colour to represent the final figure?

 

 

I created a group >150k and this should be visible on the above account

 

  • saravanan_p's avatar
    saravanan_p
    Resolver III
    3 years ago

    Dear I believe for the same location , there may be different account codes having more categories.
    Thats the reason you see 3 color for same location.
    Can you bring location in table along with account code and turnover, this would conclude and solve your use case

    • ajaydavidluke's avatar
      ajaydavidluke
      Helper I
      3 years ago

      Here is a measure I have been working on:

      When I create a table view, my measure is accurate but my calclulated column is incorrect:

      I cannot insert my measure into the legend but when I insert the same calculated column I get the adverse results.

       

      Here is my full table:

      I've tried many many combinations but the legend remains incorrect and I cannot present the data as it not accurate enough. 

      Lets strip this all back and focus in on the data set, it has multiple invoice sku lines, line value represents SKU QTY x UNIT PRICE and this is done at source.

       

      I then created a column TOTAL TURNOVER which is SUM(

      'Daily Turnover 2022'[Line Value]), I used this in the calculated column and does not work.
       
      I've also changed the column to 
      CALCULATE(IF(SUM('Daily Turnover 2022'[Line Value]) <= 5000, "<5k",
      IF(SUM('Daily Turnover 2022'[Line Value]) > 5000 && SUM('Daily Turnover 2022'[Line Value]) <= 25000, "5k > 25k",
      IF(SUM('Daily Turnover 2022'[Line Value]) > 25000 && SUM('Daily Turnover 2022'[Line Value]) <= 50000, "25k > 50k",
      IF(SUM('Daily Turnover 2022'[Line Value]) > 50000 && SUM('Daily Turnover 2022'[Line Value]) <= 150000, "50k > 150K",
      IF(SUM('Daily Turnover 2022'[Line Value]) > 150000 && SUM('Daily Turnover 2022'[Line Value]) <= 10000000, ">150k")))))).
       
      Doesnt work but the measure does?  What is missing from the column that makes it not work the same as the measure?

       

      • saravanan_p's avatar
        saravanan_p
        Resolver III
        3 years ago

        Remove calculate and sum from your code which is used to create calculated column. It should work