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.
Hi-
I am creating a matrix chart where I want to see the count of one column (subscription names) but only where the type is a specific value.
I typed but it does not work. I dont get an error but no counts are returned. I verified in the table the value in the type column is correct.
Solved! Go to Solution.
HI @Lcouch
Can you please try the following:
CALCULATE(
COUNTA('VIEW_DataAPIDetails'[SubscriptionName]),
FILTER('VIEW_DataAPIDetails','VIEW_DataAPIDetails'[Type]= "microsoft.classiccompute/domainnames")
)
if tzhis does not work can you please show a picture of the data model cinl. columns and relations as well as how the matrix visual looks like?
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Thank you so much. Sorry for the delay. I had multiple issues, one was data not in the table in non production but I used the DAX function for other reports/ tables w/ the same filter need and it worked perfect. I appreciate your quick turnaround
HI @Lcouch
Can you please try the following:
CALCULATE(
COUNTA('VIEW_DataAPIDetails'[SubscriptionName]),
FILTER('VIEW_DataAPIDetails','VIEW_DataAPIDetails'[Type]= "microsoft.classiccompute/domainnames")
)
if tzhis does not work can you please show a picture of the data model cinl. columns and relations as well as how the matrix visual looks like?
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |