Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |