Forum Discussion

syedjunaid11's avatar
syedjunaid11
New Member
3 years ago
Solved

Divide by total sum without getting divided into category

Hello, I have below table. I created average days and total sales measures. Category Days Sales AB 35 2345 AF 89 265 AG 24 50 AF 80 2376 AG 34 4596   Now I want t...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi  syedjunaid11  , if I have understood you correctly, you have to create this 2 measures: 

     

    Avg_days-Avg_total = var avg_total= CALCULATE(AVERAGE('Table'[Days]),ALL('Table'))
return
divide(CALCULATE(AVERAGE('Table'[Days]),ALLEXCEPT('Table','Table'[Categoy])),
avg_total,"-")

     

    Sum_days-Total_sales = var sales_total= CALCULATE(sum('Table'[Sales]),ALL('Table'))
return
divide(CALCULATE(sum('Table'[Days]),ALLEXCEPT('Table','Table'[Categoy])),
sales_total,"-")

     

    The result

     

    Best Regards

Bifinity_75's avatar
Bifinity_75
Icon for Solution Sage rankSolution Sage
3 years ago

Hi  syedjunaid11  , if I have understood you correctly, you have to create this 2 measures: 

 

Avg_days-Avg_total = var avg_total= CALCULATE(AVERAGE('Table'[Days]),ALL('Table'))
return
divide(CALCULATE(AVERAGE('Table'[Days]),ALLEXCEPT('Table','Table'[Categoy])),
avg_total,"-")

 

Sum_days-Total_sales = var sales_total= CALCULATE(sum('Table'[Sales]),ALL('Table'))
return
divide(CALCULATE(sum('Table'[Days]),ALLEXCEPT('Table','Table'[Categoy])),
sales_total,"-")

 

The result

 

Best Regards