Forum Discussion

dokat's avatar
dokat
Post Prodigy
4 years ago
Solved

Sum divided by unique count

Hi, I have data table in below format where i'd lke to calculate sum divided by unique count.  Basically sum of  dollar sales for Census Division then divide # of unique count of States. For Ex: In...
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, dokat ,
    I believe Measure like this will do it:

    DividedTotal = 
var _currentCensus = MAX(Financial[Census Division])
var _sum = SUM(Financial[Dollar Sales])
var _uniquestates = CALCULATE(DISTINCTCOUNT(Financial[State]),
    Financial[Census Division]=_currentCensus)

var _calculation = DIVIDE(_sum,_uniquestates)
return _calculation

     

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, dokat ,
I believe Measure like this will do it:

DividedTotal = 
var _currentCensus = MAX(Financial[Census Division])
var _sum = SUM(Financial[Dollar Sales])
var _uniquestates = CALCULATE(DISTINCTCOUNT(Financial[State]),
    Financial[Census Division]=_currentCensus)

var _calculation = DIVIDE(_sum,_uniquestates)
return _calculation

 

  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    vojtechsima  Thank you it worked perfectly!