Forum Discussion

bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago
Solved

DAX Calculation for Measure with multiple filter conditions

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...
Need Help
  • bhaskarpbi999's avatar
    bhaskarpbi999
    1 year ago

    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's avatar
    bhaskarpbi999
    1 year ago

    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/
bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago

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's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago

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/