Create a measure to multiply with different conditions

[chavanr]

Hi there, 

I am trying to create a measure for Revenue where i want to multiply a measure with the count of households and rate multipled to the total count  as per a respective category.

There are multiple conditions included in the where clause in order to pick the right rate from the description.

Can some one help with the same?

e.g. In the below example, need to calculate the revenue  as per "Service", " Service Charge" & "Description of Services"

Thanks in advance.

Cheers,

[v-angzheng-msft]

Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

[amitchandak]

@chavanr ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

In such case, it is better to move the rate from one table to another using new column 

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8