Forum Discussion

bhatsuchi's avatar
bhatsuchi
Frequent Visitor
8 years ago
Solved

DAX to count rows with same value for Column A for a value in column B

Id Email 1 [email protected] 2 [email protected] 3 [email protected] 1 [email protected] 1 [email protected] 2 [email protected] 2 [email protected] 3 [email protected] Hello! I have a table with data like above. I want to create...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    bhatsuchi,

     

    You may refer to the measures below.

    Measure =
COUNTROWS (
    FILTER (
        VALUES ( Table1[Id] ),
        CALCULATE ( COUNT ( Table1[Email] ) > DISTINCTCOUNT ( Table1[Email] ) )
    )
)

    Measure 2 =
COUNTROWS (
    FILTER (
        VALUES ( Table1[Id] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Email] ) > 1 )
    )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-chuncz-msft  , Thejeswar , Mariusz , Anonymous 

I am new in powerbi and looking for solution that counts the repeated value in a column. Note: I ma using Direct query and not Import Mode.

 

Repeated time         Count of Ids tha are repeating corresponds to (Repeated time) Column
0 times         |      3 
1 times         |      2
2 times         |      2
3 times         |      1

Data i have is like this:

 

 

ID_ColumnID_001
ID_001
ID_002
ID_002
ID_002
ID_003
ID_003
ID_003
ID_004
ID_004
ID_005
ID_006
ID_007
ID_008
ID_008
ID_008
ID_008

Please see the screenshot for deatils of my problem:

 

Thanks in advance,

Kulchandra