Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello - I created tis kind of complicated measure to calculate "the Amout to meet goal" -
Could you please help me solve this problem, if it's possible - Thank you in advance.
Solved! Go to Solution.
I did it!!! I used the SUMMARIZE function and that solve the problem !!
Hi @Anonymous
How about this measure:
AmtToMeetGoal = VAR sum1 = IF ( ( SUMX ( DISTINCT ( 'Sub List'[ContractNumber] ), ( MAXX ( DISTINCT ( 'Sub List'[ContractNumber] ), MAX ( 'Sub List'[GoalDollars] ) ) ) ) ) > [AmountB4SlicerPeriod], ( ( SUMX ( DISTINCT ( 'Sub List'[ContractNumber] ), ( MAXX ( DISTINCT ( 'Sub List'[ContractNumber] ), MAX ( 'Sub List'[GoalDollars] ) ) ) ) ) - [AmountB4SlicerPeriod] ), 0 ) RETURN IF ( HASONEVALUE ( 'Sub List'[ContractNumber] ), Sum1, SUMX ( 'Sub List', sum1 ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did it!!! I used the SUMMARIZE function and that solve the problem !!
It works but it gives me the wrong total :(. The amount that listed on column is correct but for some reason when it comes to total, it just doesn't sums it up right.