Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm working on a project where I have calculated a figure between two base values. The results are in the left table and you can see some values are positive and some negative.
My next step is to only take the positive numbers and pivot them into a table on the right. I'm having a really hard time figuring out how to do this. If I use the new measure in the filters and select "is greater than or equal to" and type 0, it filters out results in my pivot table, not the base values. Is there a way to do this?
Here's the base formula to calculate the field if there's maybe an edit I can make to it. I only need anything that's equal or greater than 0.
Cheers!
Solved! Go to Solution.
@Anonymous I *think* you are going for this:
Measure =
VAR __Table =
ADDCOLUMNS(
'Dupes Removed',
"__Diff", DATEDIFF('Dupes Removed'[Field 1], 'Dupes Removed'[Field 2], day)
)
VAR __Result = AVERAGEX( FILTER( __Table, [__Diff] > 0 ), [__Diff] )
RETURN
__Result
@Anonymous I *think* you are going for this:
Measure =
VAR __Table =
ADDCOLUMNS(
'Dupes Removed',
"__Diff", DATEDIFF('Dupes Removed'[Field 1], 'Dupes Removed'[Field 2], day)
)
VAR __Result = AVERAGEX( FILTER( __Table, [__Diff] > 0 ), [__Diff] )
RETURN
__Result
Brilliant, thank you so much! THis was exactly it. I just updated to >= to capture zeros and it's exactly what I needed. I really appreciate the help, this is amazing!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |