Reply
Lcouch
New Member
Partially syndicated - Outbound

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.

Total CloudServices =
COUNTAX(FILTER('VIEW_DataAPIDetails',[Type]= "microsoft.classiccompute/domainnames"),[SubscriptionName])
 
1 ACCEPTED SOLUTION
Mikelytics
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

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.

-----------------------------------------------------

LinkedIn

------------------------------------------------------------------
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!

View solution in original post

2 REPLIES 2
Lcouch
New Member

Syndicated - Outbound

 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

Mikelytics
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

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.

-----------------------------------------------------

LinkedIn

------------------------------------------------------------------
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!
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)