cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Re: is there a way to create a table extracting results from a measure?

Maaan, You are a Ninja. thanks a lot
Highlighted
Helper III
Helper III

Re: is there a way to create a table extracting results from a measure?

Dear @harshnathani ,

my total ranking is a sum of several measures, [Net sales rank]+[CM1 Rank]+[Customer Rank], etc..

i can create a filter where i can select each of this measures and have a different Total ranking.

my problem is with the combination of 2,3 or all of the selected ranks.

 

Total Ranking = SWITCH(TRUE(),
                MAX('Criteria for Score'[Score criteria])="Net Sales", [Net Sales Rank],
                MAX('Criteria for Score'[Score criteria])="CM1", CM1[CM1 Rank], etc..
 
Is there an elegant or just better way of having this Total ranking measure reflecting the sum of the Selected
only Elements in a slicer. in the End, i would like to have a dynamic Total rank, which will only take into account
the elements selected in the slicer.
thanks in advance
VG
Highlighted
Super User V
Super User V

Re: is there a way to create a table extracting results from a measure?

Hi @Vandergledison ,

 

How are you doing.

 

Apologies, I did not understand a bit of what you need. Can you elaborate on this requirement like you did in the first post here.

 

Also, if you can share your .pbix file. Will be helpful to understand.

 

Regards,

Harsh Nathani

Highlighted
Helper III
Helper III

Re: is there a way to create a table extracting results from a measure?

Dear Harsh, no need to apologize

its quite difficult to explain clearly what i need 😛

 

So in the file you will see that i have 2 main percentile measures. One is the Net Sales and the other is NPV. I will have more in the future.

Now the totalRank is the Sum of NetSales rank adn NPV rank. This Sum will reflect what the RankX will order.

i added a filter (it doenst need to be a filter) just to show what i need:

basically in the Box i want to show the final Rank dynamically based on the factors that contribuite to the total RAnk. 

If i select only Net Sales in the box, it should only show the Rank based on Net sales, If i click Net sales and NPV, it should show the Sum of both of them..and so on.

i hope its clear when you see the file.

thanks a lot

VG

PrioList100b 

 

Highlighted
Super User V
Super User V

Re: is there a way to create a table extracting results from a measure?

@Vandergledison ,

Thanks, I understand what you require now. 

 

Please see below post,

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Slicer-mulitple-value-store-and-then-use-to-d...

 

I am really not sure how this can be done as the requirement is to add measures based on Selected Slicer Value. If multiple values are selected, then add multiple measures.

 

 

There can be a different method though, where your slicer value contains values like for Scoring Criteria

 

1.jpg

 

This may not be feasible incase you  have a lot of parameters to calculate your final rank.

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

 

Highlighted
Helper III
Helper III

Re: is there a way to create a table extracting results from a measure?

Thanks a lot @harshnathani .

 
               

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors