Thank you all for your assistance, I’m slowly getting to a resolution on this issue. I have fixed the correct Totals issue
The Card Image below, shows that the test 14 mR measure shows as 76.159, really close to the required number of 76.112
The DAX below is how I solved it.
test 14 mR =
SUMX(
FILTER(
SUMMARIZE('Contract Review','Contract Review'[Review No]),
[test 3 mR] > 0),
[test 3 mR])
You don’t want to know how long I messes around with this today, I’ll be claiming overtime for sure! This simple solution came to me after watching on of Sam’s video’s
Iterating Logic Through Virtual Tables - Advanced DAX Concepts In Power BI
Unfortunately I still need to resolve the first record issue. Shown below in the Table image. the first value shown as 0.032 under the column test 3 mR should actually be blank.
I did play around with the suggestion from Ankit J, here is the Dax measure, it did not work
test 10 mR =
VAR MinRec =
CALCULATE ( MIN ( 'Contract Review'[Review No] ), ALLSELECTED ( 'Contract Review'[Review No] ) )
RETURN
IF ( SELECTEDVALUE ( 'Contract Review'[Review No] ) = MinRec, BLANK (), [test 3 mR] )
Thnaks
J