Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to calculate difference between two columns - related column and count column

I'm struggling with this.  I want to create a column that calculates the difference of (First RequiredShiftA) and (CountDuringShiftA) columns.   This started as two tables.  I created new columns i...
Calculations
DAX
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
7 years ago

Are you sure you are checking the result in the data view?

2 - 2 = 6  sounds like having the visualization with a value of SUM of calculatedColumn.

 

Can you show a picture with the two columns and the substract result from the DataView?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

The one column was a quick measure and doesn't show up in the data view.

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    7 years ago

    Then don't use a "quick measure" and create a "calculated column" with the substract.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I've been trying.  I get a lot of errors.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I think this is what i'm trying to do - but have no idea - this DAX stuff is crazy.

         

        I basically want a count of all the during roles for shift b that gets subtracted from the # of required roles for shift b.  

         

        CALCULATE(

            COUNTA('Contact Export PowerBI'[During Section and Role]),

            'Contact Export PowerBI'[During Shift] IN { "B Shift" } - 'Contact Export PowerBI'[RequiredShiftB])