SUMIF Function

[Anonymous]

Hi,

I have a calculate measures similar to the one in the table below. I would like to get to the Segment Coverage value through appropriate DAX formula. How to get to this point. In Excel, I would have used a IF or SUMIFS function.

By the way Segment Sales, Segment Share and XYZ Sales, XYZ Marketshare are calculated measures.

Help is appreciated.

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Create a measure

Segment Coverage value = SUMX(FILTER(Table1,[XYZ Marketshare]>0),[Segment Share])

Best Regards

Maggie