Forum Discussion

Hitofrancis's avatar
Hitofrancis
New Member
8 years ago

Flag Column creation for KPI calculation based on duplicate values

Hello there,

 I’m a new user on Power BI, but so excited about it. Even though I'm still getting familiar with DAX (A beginner).

 

I would like to achieve the following KPI calculation.

 

 

 

 

Above, data that really get close to my entire data base. The idea here is to create those columns on yellow; the first one, a flag column that help me out to count how many Back Order I have during a specific period of time; and the second, a column that helps identify which of my orders were actually a back ordered.

 

Once those columns are created, the idea is to report those BO like this: 

 

Do not know if helps or not, but please realise that the report is based on Reporting Date not in Receipt Date.

 

 

 

 

 

 

Need Help

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Hitofrancis,

     

    You may refer to the following DAX first.

    Column =
IF (
    COUNTROWS ( CALCULATETABLE ( Table1, ALL ( Table1[Receipt Date] ) ) ) = 1,
    0,
    1
)
    • Hitofrancis's avatar
      Hitofrancis
      New Member
      8 years ago

      Thank you for your reply.

       

      Sadly the formula didnt work for me for now, it created a calculate column with a value of 1 in every row. 

       

      The results I want to get its 1 = Unique combination of Order # & Order Line & Receipt date; and a 0 when there is Order  &Order Line & with two or more Receipt date.

       

      Thank you,