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...
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

What formula do you use?

 

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
    Icon for Community Champion rankCommunity 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