weaselmcguff
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 246
I am trying to create a new measure based upon a filtered result.
New Measure called = FFPY
1st Value = 'Current'[Total Shipped] (3057 = Value)
2nd Value = Filtered results value (104 = Filtered Value)
Starts out from 'Current'[Total Issues] (199 = Original Value)
Filters under it is:
Install Type = Install
Defects = Yes
Class = Ops and Sales
Should be something like
FFPY = divide('Current'[Total Issue], 'Current'[Total Shipped]
Should be 96.5
But shows up as 93.49
Thanks for your assistance
New Measure called = FFPY
1st Value = 'Current'[Total Shipped] (3057 = Value)
2nd Value = Filtered results value (104 = Filtered Value)
Starts out from 'Current'[Total Issues] (199 = Original Value)
Filters under it is:
Install Type = Install
Defects = Yes
Class = Ops and Sales
Should be something like
FFPY = divide('Current'[Total Issue], 'Current'[Total Shipped]
Should be 96.5
But shows up as 93.49
Thanks for your assistance