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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.