cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hakun_Matata
Frequent Visitor

Dynamic sum the measures based on the a slicer with these measure name

Hi,

 

I have a table which is basically contains rankings for different facts, all these rankings are measures which use the rankx formula.

 

What i want to achieve is to have a slicer with these factor names and by selecting different factor names in this slicer, i would like to have a new measure which sums the ranking measures for the selected factor (the selected measure can be either single or multiple).

 

Any idea on if this is possible to achieve in power BI? thanks in advance!

 

Best,

Zhengyang

1 ACCEPTED SOLUTION
Hakun_Matata
Frequent Visitor

okay, i have fixed myself. thanks anyway.

View solution in original post

3 REPLIES 3
Hakun_Matata
Frequent Visitor

okay, i have fixed myself. thanks anyway.

View solution in original post

amitchandak
Super User IV
Super User IV

@Hakun_Matata ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
I think you need something like

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi amitchandak,

 

For example, i have a table below which all the columns are a measure using rankx for different factors:

Company      Factor 1     Factor 2     Factor 3     Factor 4

Company1         1               2                 3               2

Company2         2               1                 2               3

Company3         3               3                 1               1

 

what i want to achieve is to have a slicer for different factors:

Factor 1 (Selected)

Factor 2 (Selected)

Factor 3

Factor 4

 

And the new measure X will be the sum of all the ranking scores i have selected:

Company      Factor 1     Factor 2     Factor 3     Factor 4     X

Company1         1               2                 3               2            3

Company2         2               1                 2               3            3

Company3         3               3                 1               1            6

 

if i choose Factor 1 + Factor 2 + Factor 3, the X will show the sum of these 3 factor rankings.

 

Best,

Zhengyang

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates