Forum Discussion

bleaf's avatar
bleaf
Regular Visitor
8 years ago

Dynamic change in X Axis

Hi  I have a bar chart including each company sales (Table1) and benchmark sales (Table2). The benchmark calculation is a measure of average sales based on the selection of Category of companies. Fo...
Need Help
bleaf's avatar
bleaf
Regular Visitor
8 years ago

Thank you for inputs. It's same result after I added ALLSELECTED the measure:

SalesBenchmark =
VAR AverageSalesPerCategory = IF(HASONEVALUE(Sales[Category]),CALCULATE(AVERAGE(SalesBenchmark[Sales]),FILTER(ALLSELECTED(SalesBenchmark),SalesBenchmark[Category]=[CategorySlicer])))
VAR AverageSalesCrossAllCategory = CALCULATE(DIVIDE(SUM(SalesBenchmark[Sales]),DISTINCTCOUNT(SalesBenchmark[Company])))
RETURN
IF(HASONEVALUE(Sales[Category]),AverageSalesPerCategory,AverageSalesCrossAllCategory)

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

bleaf,

 

Try the second calculate function.

  • bleaf's avatar
    bleaf
    Regular Visitor
    8 years ago

    Still same after I changded the second calculate in variable. I guess I have to recreate data model to make it works. Thank you.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    hi bleaf,

     

    Share the link from where i can download your file.

  • bleaf's avatar
    bleaf
    Regular Visitor
    8 years ago

    Hi Ashish,

     

    Thank you very much. I am going to try different approach to solve this issue. Thanks.