Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
i tried but first step is not working it gives me "The expression specified in the query is not a valid table expression." error
@drogo96 Hii
I think u are doing sth wrong. I checked and it worked. Share your pbix file.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |