Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Query when using a filter

Hi

I have created a DAX formula that counts an attribute based on a filter.

Is it possible to have a filter coming from two different dimension groups.

 

In the example below, I want to count all Table A field A records where the TableA.field3 = 1 and TableB.Field2 =2 . 

 


CALCULATE(COUNT('TableA'[FieldA]), Filter('TableA', [Field3] = "1"  &&
('TableB'[Field2] = "2" )))

 

When I try and create the TableB Field 2 part of the DAX query, it is relating back to Table A.

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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