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

I used the same formula, but I see blanks for records which are duplicates

Sean's avatar
Sean
Community Champion
9 years ago

Okay so how are the two tables related? Are you saying you are getting only one Status per Student_No in Table 1?

 

  • 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

      • 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