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.

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.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.