The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.