Forum Discussion

DataAnalysis's avatar
DataAnalysis
Frequent Visitor
4 years ago
Solved

Problems with duplicate data processing after a separate column

Hello. I use PowerBI in Korea. Recently, I've been doing a lot of different things since I started using PowerBI. There is a recent issue, and I am writing here to ask for your advice. There is d...
Need Help
  • ribisht17's avatar
    ribisht17
    4 years ago

    Please make use of Column Tool to create this formula instead

     

    Custom Case2 = IF( ( RANKX (
    FILTER (
    'community_assist_duplicate (2)',
    'community_assist_duplicate (2)'[Working Number]
    = EARLIER ( 'community_assist_duplicate (2)'[Working Number] )
    ),
    'community_assist_duplicate (2)'[Working PLace],
    ,
    ASC,
    DENSE
    )) =1,'community_assist_duplicate (2)'[Working Hours],"0")

     

     

     

    Regards,

    Ritesh 

    "Please mark the answer if it helps you so that it can help others as well"

DataAnalysis's avatar
DataAnalysis
Frequent Visitor
4 years ago

Thank you very much for your dedicated advice.
As you advised, DAX modified the syntax to match my Data Column name.

(Working Number  = CaseNumber

Working Place = MPC

Wroking Hours = ActualHours)

 

However, grammatical errors continue to occur.
I will also show you my Data column.

Error Name : 

A single value for column 'actualhours' in table 'community_assist_duplicate (2)' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

My PowerBI level is a beginner, so I'm very ashamed.
I'd appreciate it if you could help me a little more.

ribisht17's avatar
ribisht17
Super User
4 years ago

Hey nothing to be ashamed, I am happy to help if I can, this time I think my mistake, please put the 0 within the quotation then you should not get the error, see the bold-one below

 

 

SUGGESTION 1: You should make use of your table name where you are in, community_assist_duplicate is my table name

 

SUGGESTION 2: Keep 0 within quotations

FILTER (
'community_assist_duplicate (2)',
'community_assist_duplicate (2)'[Working Number]
= EARLIER ( 'community_assist_duplicate (2)'[Working Number] )
),
'community_assist_duplicate (2)'[Working PLace],
,
ASC,
DENSE
)) =1,'community_assist_duplicate (2)'[Working Hours],"0")