Functions

[AmalrajRRD1]

Hi all,

I have one doubt on conditional calculation. for example i have category column, in category column have different filed like "POC","LON","FLD". I want to get "POC" total value . 

Is there possible to get my value.

Help  me on this

Thanks

[v-yuta-msft · Accepted solution]

Hi AmalrajRRD1,

You can create a measure “Total of POC” using DAX:

Total of POC = CALCULATE(SUM(Table1[Value]), Table1[Category] = "POC")

PBIX here:

https://www.dropbox.com/s/01dzvaoxtkui1b0/For%20AmalrajRRD1.pbix?dl=0

Regards,

Jimmy Tao