Custom Column Power BI

[JackReagan]

I am hoping the collective minds can help me with a simple example using the custom columns in Power BI. 

I have a rather simple data set which has three columns; ProjectID, ModelID and TotalAmount. Project ID is a unique ID, ModelID has two values Rem and Orig and Total Amount has various amount values.  I want to create a custom column that will display the Total Amounts for only those Total Amounts that also have Model ID = Orig.  

Data set example:

Project ID         ModelID             Total Amount

123                   Rem                    $400.00

123                   Orig                    $780.00

234                   Rem                    $559.00

234                   Orig                    $700.00

Custom column should display values for only those records that have ModelID = "Rem"

Report Example with Custom column

Project ID            Custom column

123                      $400.00

234                      $559.00

[RolandsP · Accepted solution]

You should write following DAX formula:

Custom column = IF (TableName[ModelID] = "Rem", TableName[Total Amount], Blank() )

[Ashish_Mathur · Accepted solution]

Hi,

Why do you wan to use a Custom Column.  Use a measure instead.  Drag Project ID to the row labels and ModelID to the filter section.  Select the criteria as Rem.  Write the following measure

=SUM(Data[Total Amount])

Hope this helps.

[JackReagan]

Ashish

You were right.  Once I figured out the measure functionality it seemed to be the right path.  Whats great about DAX is that you can do one thing many ways.  I appreciate your help. 

Tom

[Ashish_Mathur]

You are welcome.

[RolandsP · Accepted solution]

You should write following DAX formula:

Custom column = IF (TableName[ModelID] = "Rem", TableName[Total Amount], Blank() )

[JackReagan]

Thanks Roland.  Your DAX formula helped me create my measure.  I appreciate your help. 

[JackReagan]

I meant to say ... the Total Amounts for only those Total Amounts that also have Model ID = Rem.