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.     ...
Need Help
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,