Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have two tables. I have a measure to count rows based on date and status. I need to add another filter to a related table (i have set up a relationship with an ID). It needs to filter values where status in table 2 is also "Open". How do i add another filter to this measure that also applies the filter from another related table?
Solved! Go to Solution.
Give this a try
measure1 =
CALCULATE (
COUNTROWS (
FILTER ( 'Table1', [Invoice Date] <= TODAY () && [Status] = "Open" )
),
'Table2'[Field] = "something"
)
Give this a try
measure1 =
CALCULATE (
COUNTROWS (
FILTER ( 'Table1', [Invoice Date] <= TODAY () && [Status] = "Open" )
),
'Table2'[Field] = "something"
)
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |