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/
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

bhaskarpbi999 , Try using

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

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

 

  • ajohnso2's avatar
    ajohnso2
    Icon for Solution Supplier rankSolution Supplier
    1 year ago

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

      Hi John,

      Thanks for your suppor and suggestions and it works now.

       

      Regards,

      Bhaslar

       

       

       

  • 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/