Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm struggling to find a working combination of filters and then using USERELATIONSHIP to return values based on a different date field. Dummy example below and file too.
I'm trying to use a combination of filters to return (1) successful 'pitches' over £500K+ (2) that return based on a secondary date field.
(1) is fine just using two FILTER functions in the 'Successful over £500K+' measure.
(2) on it's own works in the 'Value by Confirmed Date' measure - honouring the intial filter context from the slicer.
Putting these into one measure, as in the screenshot produces blanks, rather than where expected.
Solved! Go to Solution.
Hi
Try to use like this :
Calculate ( your function with filters ) ; userelationship()
So u just put your measure inside another Calculate measure :
Hope its clear
Hi
Try to use like this :
Calculate ( your function with filters ) ; userelationship()
So u just put your measure inside another Calculate measure :
Hope its clear
Thanks this worked! I'm not entirely sure why, I guess something to do with context/ context transition!? I just needed the extra 'CALCULATE' wrap around as the tables were already related.
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |