Forum Discussion

NPArulventhan's avatar
NPArulventhan
New Member
10 years ago
Solved

Doubt in calc measure

Dont mistake me its look like silly question but i have to clarify
 
whenever i create a new measure it will come under my first table , how can i move to my related table. 
 
bec in tableau we can easily drag and drop the field here i tried but i can't.
  • cool

    select the measure and Click the "Modelling ribbon" there u can find the home table of you created measure.
    there you can choose the table u want.

4 Replies

  • Baskar's avatar
    Baskar
    Resident Rockstar

    cool

    select the measure and Click the "Modelling ribbon" there u can find the home table of you created measure.
    there you can choose the table u want.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Baskar,

       

      thank you for the answer. I tried it, it only allows to use single value for calculation, I don't need a colum to hold one same value. I want to add two values from 2 different tables as derived column. How to get the result by calculating each row? 

       

      Thank you!

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        WIPFeesInvoiced = WIPAmount[Wfee] + WIPBilled[Write Up/Down]

        Dax is like this. I just want to add values of these two columns as a derived column.

         Relationship of tables

         

        error message