Forum Discussion

powerbi_bi's avatar
powerbi_bi
Frequent Visitor
9 years ago

TRUE/FALSE from another table

Hi, I have two tables in tabular model Table1 has multiple records with details Table 2 has distinct records with Status column (TRUE/FALSE)   How should I bring in this column to Table1   I t...
powerbi_bi's avatar
powerbi_bi
Frequent Visitor
9 years ago

Hi Sean,

Firstly, thank you for the quick responses

 

I'm sorry, the problem is with my data

I investigated it and found out that Table2 doesnt have all the records as Table1 and hence the BLANKS in Table1

 

Thanks Sean

 

 

powerbi_bi's avatar
powerbi_bi
Frequent Visitor
9 years ago

Hi,

I have a DAX formula to calculate total amount

 

TotalAmount:=CALCULATE (
SUMX (
SUMMARIZE (
Table1,
Table1[Report_Date],
Table1[Student_ID],
Table1[Assignment_No],
Table1[CreditAmount]
),
Table1[CreditAmount]
),
Table1[S_Name] = "TotalFee"
)

 

Now I want to use the same formula based on a True/False column

I want to add IF condition to the above formula

 

IF its TRUE then Calculate

 

Thanks