How do exclude a certain row's calculation in a Matrix?

[GAPER]

Hi all, here is my data structure

How do i create a generic fomula for Multiple in PowerBI to exclude A from it? (i.e., excluding A when applying the fomula in column E but keep C and D including A)

Thanks. 

[GAPER]

I need to exclude Project A from the total calculation.

[Ashish_Mathur · Accepted solution]

Hi,

Try these measures

Ratio = divide([cash inflow],[cash outflow])

Ratio final = calculate([Ratio],Data[Project]<>"Project A")

Hope this helps.

[Ashish_Mathur]

Hi,

I am not clear about what you want.  Assuming Cash inflow and Cash outflow are measure, write this measure

Measure = divide([Cash inflow],[cash outflow])

Hope this helps.