how to count of the count

[drogo96]

I have a matrix with phone numbers and count of the phone numbers. Now I need to display the count of all numbers which has count of 100,99 etc .Like there may be 150 numbers with count 100. or 98 numbers with count 99 etc  

[drogo96]

i tried but first step is not working it gives me "The expression specified in the query is not a valid table expression." error

[MohammadLoran25]

@drogo96 Hii

I think u are doing sth wrong. I checked and it worked. Share your pbix file.

[MohammadLoran25]

Hi @drogo96 ,

1-Create below CALCULATED COLUMN in your Table (Calculated column, Not Measure)

PhonNoCount =
CALCULATE (
    CALCULATE (
        COUNTROWS ( PhoneNumberTable ),
        FILTER (
            PhoneNumberTable,
            PhoneNumberTable[msisdn] = SELECTEDVALUE ( PhoneNumberTable[msisdn] )
        )
    )
)

2-Create the measure:

FinalMeasure =
CALCULATE (
    COUNTROWS ( VALUES ( PhoneNumberTable[msisdn] ) ),
    PhoneNumberTable[PhonNoCount] = SELECTEDVALUE ( PhoneNumberTable[PhonNoCount] )
)

3-Put the calculated column "PhoneNoCount" and "FinalMeasure" in a Table visual and get what you need.

It helped? Mark it as an accepted solution.
Regards,
Loran