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,

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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi powerbi_bi,

 

Do you mean you only want to caluculate the rows in which the value of True/False column is True? 

 

If so, please try below:

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

If I have something misunderatood, please post more detaied data and your expect output.

 

Thanks,
Yuliana Gu