Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Column - Distinct Count By Another Column and Filter By Column

I have a table with 3 columns, Customer Number, Account Number & Flag. I want to create a calculated column(NOT A MEASURE) which counts the number of accounts per customer when the flag is set to yes...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello Anonymous  Give this a try

    Total Business Investment Products =
CALCULATE (
    DISTINCTCOUNT ( 'Fact'[AccountNumber] ),
    ALLEXCEPT ( 'Fact', 'Fact'[CustomerNumber] ),
    'Fact'[Flag] = "Y"
)
Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,


Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.


Best Regards
Icey