Forum Discussion

letiziadistasi's avatar
letiziadistasi
New Member
3 years ago
Solved

Count distinct value

Hello! I have a database where for each accounts there is an employee. There is the case where one or more employee have the same accounts, so the accounts name is duplicated in database. Each Accou...
Need Help
  • PijushRoy's avatar
    PijushRoy
    3 years ago

    letiziadistasi 

     

    If account code is duplicate, please use DISTINCTCOUNT

    Count Tier C = CALCULATE ( DISTINCTCOUNT( Account [Code]) , Filter('Account', 'Account'[TIER] = "C"))
    Total Count = DISTINCTCOUNT( Account [Code])
    % Tier C  = Count Tier C/Total Count


    Let me know, it works or not

    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

PijushRoy's avatar
PijushRoy
Community Champion
3 years ago

letiziadistasi 

 

If account code is duplicate, please use DISTINCTCOUNT

Count Tier C = CALCULATE ( DISTINCTCOUNT( Account [Code]) , Filter('Account', 'Account'[TIER] = "C"))
Total Count = DISTINCTCOUNT( Account [Code])
% Tier C  = Count Tier C/Total Count


Let me know, it works or not

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos