Summing by 2 category but total not showing

[bo_wang5]

Hello All,

I'm trying to create a sum based on 2 different category measures.  "Forecast Status" and "Status" and it's not showing me the total.  Please help, Thanks in advance for any assistance.

In forecast and won =

if([Forecast Status]="in forecast",If([Status]="won",[Sum Won Q3],0))

[VahidDM]

Hi @bo_wang5 

Is [Sum Won Q3] a measure? 

BTWTry this:

In forecast and won = SUMX(filter(Data,Data[Forecast Status]="in forecast"&&Data[Status]="won"),[Sum Won Q3])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[bo_wang5]

Thank you so much for responding.

Yes that is correct [Sum Won Q3] is a measure, it is calcuated as

Sum Won Q3=CALCULATE(sum(data[ASO: Amount (converted)]),filter(data,Data[Data Entry or Type]="Won-Q3"))

where data[ASO: Amount (converted)] and Data[Data Entry or Type] are physical columns. 

I tried your code that you suggested but it did not work.  both the "Forecast Status" and the "Status" are measures as well. here is my code for "Status" which uses the [Sum Won Q3] measure

Status =

if(hasonevalue(Data[Reference]),

IF ( [Sum Won Q3] <= 0, "Not Won", "won" )

)

[bo_wang5]

Slight update to the formula, I just need to know how I can sum up the total of the entire column.  Once I have that I can use it for additional calculations. Thanks.

In forecast and won = if([Forecast Status]="in forecast",if([Status]="won",[Sum Won Q3],0),if(HASONEVALUE(Data[Reference]),0,"need formula to capture total"))