Cumulated sum first row show as blank

[apohl1]

Hi all,

I'm doing an analaysis where I'm grouping accounts based on their cumulated contribution (I do this both for potential and for sales). Please see formula below. The formula works well for one of the datasets (potential) but for the sales dataset (which is much bigger) it often return a blank for the account with largest sales. For all other accounts the calculation works correct but the largest account appear as blank/no contribution which is incorrect. Does anyone know what could be causing this?

Thank you in advance!

Cumulated Sales =

VAR thisAccountSales = [Sales] 

VAR TotalSalesAllAccounts =

CALCULATE([Sales],ALLSELECTED('C Account'[C. Account Name]))

var blanks = ISBLANK([Sales])

RETURN

SWITCH(

TRUE(),

blanks,BLANK(),

CALCULATE(

[Sales],

FILTER(ALLSELECTED('C Account'[C. Account Name]), [v]>= thisAccountSales)

) / TotalSalesAllAccounts )

[Anonymous]

Hi @apohl1,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng