Cumulated sum first row show as blank

apohl1 — Wed, 22 Jun 2022 14:13:50 GMT

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 )

Re: Cumulated sum first row show as blank

Anonymous — Mon, 27 Jun 2022 02:50:56 GMT

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

topic Cumulated sum first row show as blank in DAX Commands and Tips

Cumulated sum first row show as blank

Re: Cumulated sum first row show as blank