DAX Calculation for Measure with multiple filter conditions

[bhaskarpbi999]

Hi,

I have a measure Rev CY (Revenue Current Year) which is defined using below formuls.

Rev CY = CALCULATE([RevRaw],MthCal[DateVisCY] = TRUE()

I need help to write formula to get Revenue for Current year with condition as Services="STD" and Delitype="Resi" and the columsn are highlighted in yellow of below screenshot.

The requirement is now we have all data for customers in above visual need so that percentage can be calculated  like below 

Rev CY data customer wise liek /Rev CY for STD and Resi (formula needed)

Could you please assist me thanks for your support.  I am always available to provide additional details if needed.

Regards,

Bhaskar

[bhaskarpbi999 · Accepted solution]

Hi Gautam,

Thanks for your support.

I have tried the above formula getting below error.

Error - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Regards,

Bhaskar

[bhanu_gautam]

@bhaskarpbi999 , Try using

DAX
Rev CY STD Resi =
CALCULATE(
[RevRaw],
MthCal[DateVisCY] = TRUE(),
Services = "STD",
Delitype = "Resi"
)

[bhaskarpbi999 · Accepted solution]

Hi Gautam,

Thanks for your support.

I have tried the above formula getting below error.

Error - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Regards,

Bhaskar

[bhaskarpbi999 · Accepted solution]

Hi Gautam,

Kudos for your great support and it works now with below formula

Rev CY STD Resi =

CALCULATE(

[RevRaw],

MthCal[DateVisCY] = TRUE(),

MktServ[CombServCd] = "STD",

DeliType[DeliType] = "Resi")

I am accepting it as as solution . Many thanks/

[ajohnso2]

You have taken @bhanu_gautam suggestion at face value without checking it. You didnt provide the table names for Services or Delitype, you need to fully qualify these.

For example 'TableName'[Services] / 'TableName'[Delitype]

[bhaskarpbi999]

Hi John,

Thanks for your suppor and suggestions and it works now.

Regards,

Bhaslar