- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Count of a column and filter on another
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
-----------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
-----------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-22-2024 11:36 AM | |||
04-24-2024 05:25 AM | |||
06-05-2024 12:54 AM | |||
Anonymous
| 12-09-2019 02:36 AM | ||
03-30-2022 03:26 PM |
User | Count |
---|---|
117 | |
96 | |
83 | |
55 | |
46 |