Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Robert NGUYEN]

Hi all,

Hope you can help me out with this one.

I’m trying to create a mesure with a condition but I’m failed.
It seems very simple at first but it is not !!

Amount calculated is If status is R then Store Amount  Else Amount

Thanks in advance

——————————
Boby

——————————

[colin mcilwain]

Hi ,

try this.

Amount Calculated = 
var __Store=SELECTEDVALUE('Table'[Store])
var __Status=SELECTEDVALUE('Table'[Status])
var __Tot_R=calculate(sumx(ALLSELECTED('Table'),[Amount]),'Table'[Store]=__Store)
var __Tot_T=sum('Table'[Amount])
return if(__Status="R",__Tot_R,__Tot_T)?

?

Colin.

——————————
colin mcilwain
Lead Process Specialist
——————————
——————————————-

[Robert NGUYEN]

Hi Colin,

Which table i have to put here ?

ALLSELECTED('Table')?

Thank you

——————————
Boby
——————————
——————————————-

[colin mcilwain]

Hi ,
replace ‘Table’ with the name of your table.

Amount Calculated = 
var __Store=SELECTEDVALUE('MyTableName'[Store])
var __Status=SELECTEDVALUE('MyTableName'[Status])
var __Tot_R=calculate(sumx(ALLSELECTED('MyTableName'),[Amount]),'MyTableName'[Store]=__Store)
var __Tot_T=sum('MyTableName'[Amount])
return if(__Status="R",__Tot_R,__Tot_T)

Colin.?

——————————
colin mcilwain
Lead Process Specialist
——————————
——————————————-

[Robert NGUYEN]

Hi Colin,

each colum of my table is a tablename distinct :
Store is store
Name is User
Status is User
Amount is revenue
amount calculated is a mesure of Amount.

My formula :
amount]calculated =
var __Store = SELECTEDVALUE(Store[StoreName])
var __Status = SELECTEDVALUE(User[Status])
var __Tot_R = calculate(sumx(ALLSELECTED(User), [total amount] ),Store[StoreName]= __Store)
var __Tot_T = [total amount]
return if (__Status =”R”, __Tot_R, __Tot_T)

but  :

——————————
Boby
——————————
——————————————-

[Robert NGUYEN]

Hi Colin,

It’s working !! my bad.
Your formula was ok.

Thank you very much for your help. Appreciated

——————————
Boby
——————————
——————————————-