Forum Discussion
Solved
Distinct Identifier
I have a dataset which i need to add a column that labels whether or not a store location is unique. When a store has multiple products my data is providing the total units for all products in the co...
Infact the formula can be reduced to following. If you need result as Binary, you can chantge the data type to Binary from the Modelling tab>>formatting section. 1 is equivalent to TRUE, 0 is equivalent to FALSE
Column Formula = VAR myrank = RANKX ( CALCULATETABLE ( 'TableName', ALLEXCEPT ( 'TableName', 'TableName'[Store], 'TableName'[City] ) ), [Product], , ASC, DENSE ) RETURN IF ( myrank = 1, 1, 0 )
Try this as a Calculated Column
Column =
VAR IsUnique =
CALCULATE (
COUNTROWS ( 'TableName' ),
ALLEXCEPT ( 'TableName', 'TableName'[Store], 'TableName'[City] )
) = 1
RETURN
IF (
IsUnique,
1,
RANKX (
CALCULATETABLE (
'TableName',
ALLEXCEPT ( 'TableName', 'TableName'[Store], 'TableName'[City] )
),
[Product],
,
DESC,
DENSE
) - 1
)
Zubair_Muhammad This is almost accurate. I have a lot values that end up as 2 or more. One goes up to 23. Is it possible to make it a bianary result like a Yes or No?