Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculating 3 different measures urgent

Hi All,

 

Afternoon to you guys, I need some assistance.

 

I created 5 separate mesaures =Measure (1)C5-D5(Measure 2)+E5(Measure 3)+F5(Measure 4)

 

I tried this formula: but it didn't give the expected result. 

XXXX = (Sales[SMeasure1])-(Sales[Measure 2])+(Sales[Measure 3])+(Sales[Measure 4])

 

All of the above mention goes into another mesaure I have to create. How can I generate the DAX formula?.

 

Treat as urgent 

2 Replies

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Amitchandak,

       

      Thanks for your response. I've put together sample data from the master file.

      I need create measures as mentioned in my earlier write up.