Sum of the calculated measure Column

[RanjanThammaiah]

Hi All,

I am stuck in one of the formula where i need to show the IF along with Sum of the column total.

Please check the below formula if i can modify and get it done correctly.

Advisory SLI = VAR AdvSLI= IF([Advisory %]>0.1,1,0)

return

IF(HASONEVALUE(SLI[AccountName]),

AdvSLI,

COUNTX(VALUES(SLI[AccountName]),AdvSLI))

[amitchandak]

@RanjanThammaiah , seems like you are mixing column and measure here

Columns could be

AdvSLI= IF([Advisory %]>0.1,1,0)

AdvSLI 1 =if(not(isblank(SLI[AccountName])),AdvSLI,sumx(SLI,SLI[AdvSLI]))

Can you please explain with an example. Also, share sample data and sample output.

[v-yuta-msft]

@RanjanThammaiah ,

The info you post is not complete. Please share sample data and clarify more details about your requirement and expected result.

Regards,

Jimmy Tao

[Greg_Deckler]

Can't tell exactly what you are going for. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But maybe this will help? This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907