Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
amirghaderi
Helper IV
Helper IV

Weighted progress % Curve

How can I get the below Weighted Actual % to be calculated at the bottom to be "sum of values calculated at each row of Weighted Actual%" and not the multiplication of sum of both columns. In the below example it should be 23.47%

amirghaderi_3-1686129376201.png

 

 

I want this get recalculated when i filter on each CBS or package.

 

I have attached the sample file which I am using.

 

https://www.dropbox.com/t/tthbtJFgM5oKRD74

 

 

 

 

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @amirghaderi ,

 

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure. 

_Weighted Actual % = 

SUMX(

    SUMMARIZE(

        'Packages',

        'Packages'[CBS],

        'Packages'[Package Description],

        "total",[Weighted Actual %]

    ),

    [total]

)

(3) Then the result is as follows.

vtangjiemsft_0-1686275260719.png

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

 

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

Hi @amirghaderi ,

 

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure. 

_Weighted Actual % = 

SUMX(

    SUMMARIZE(

        'Packages',

        'Packages'[CBS],

        'Packages'[Package Description],

        "total",[Weighted Actual %]

    ),

    [total]

)

(3) Then the result is as follows.

vtangjiemsft_0-1686275260719.png

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.