cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User V
Super User V

Re: Percentile.inc aplied to all visible rows in measure column

Hi @Vandergledison 

 

Please find the pbix.

 

https://we.tl/t-erx0mbD03j

 

Regards,

Harsh Nathani

 

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

Highlighted
Helper III
Helper III

Re: Percentile.inc aplied to all visible rows in measure column

Thanks Harsh,

i still need to dig on the video and study all measures.

just a quick question, in the end i will have a Filter where i will select the prjects i want to visualize.

do i need to create a relationship with the Measured Table or isnt necessary? i noticed that if i dont have the relationshipt it wont filter. however, i thought that the MEasure Table calculate the values based on my main Data table, therefore that table has a relationship with the projcts Nr. table and i tought that would be filtered anyways.

thanks

Vandergledison

Highlighted
Super User V
Super User V

Re: Percentile.inc aplied to all visible rows in measure column

Hi @Vandergledison ,

 

Please find the pbix attached.

 

https://we.tl/t-gP09fMN6WE

 

 

This helps in filtering and ranking your products.

 

 

Regards,

Harsh Nathani

 

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

 

View solution in original post

Highlighted
Helper III
Helper III

Re: Percentile.inc aplied to all visible rows in measure column

Harsh, you hit the nail in the head. 

now i will just need to dig in and undestand the measures you´ve wrote.

thanks again for the suport

VG

Highlighted
Super User V
Super User V

Re: Percentile.inc aplied to all visible rows in measure column

Hi @Vandergledison ,

 

Always a pleasure to help you. 

 

And in the process, I got some of my concepts cleared too and found some interesting things on power BI.

As an examplewhile declaring variables var __.80 will give you an error, while var __80 will not.

 

Thanks for your patience.

 

Regards,

Harsh Nathani

Highlighted
Helper III
Helper III

Re: Percentile.inc aplied to all visible rows in measure column

My Friend, i just noticed that if i select only some of the product in the filter, the ranking won't change.

the ranking of each product should change when the filter changes. if all are selected, it will work, but if only 5 projects for example are selected, the ranking are the same and keep the same whatever the filter shows...

any idea?

thanks

Highlighted
Super User V
Super User V

Re: Percentile.inc aplied to all visible rows in measure column

Hi,

Can you share what is the criteria for ranking.

In your earlier post you had mentioned that you want to rank 5 incase it falls between .80percentile and 60percentile.

Pls share me the entire business case so that I can help solve the problem.

Regards,
Harsh
Highlighted
Helper III
Helper III

Re: Percentile.inc aplied to all visible rows in measure column

Hi,

i would like to rank 5 (higher than 80p), 4 (higher than 60p), 3 (higher than 40p), 2 (higher than 20p) and 1 for the rest.

the idea is if i have 100 products i would have a certain ranking, by changing the filter to 50 products(for ex.) it should show the new ranking based only on this selected 50 projects.

i hope its more clear now.

the link with the file bellow

thanks a lot

Prioritization report 

Highlighted
Super User V
Super User V

Re: Percentile.inc aplied to all visible rows in measure column

Hi @Vandergledison ,

 

Here you go. Hope this is what your requirement is.

 

Please find the pbix file attached.

https://we.tl/t-SZhdC34XRf

 

 

123.JPG

 

 

 

You do not need the newly calculated table. There is a function in DAX for %ile calculation for expressions.

 

Regards,

Harsh Nathani

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

View solution in original post

Highlighted
Helper III
Helper III

Re: Percentile.inc aplied to all visible rows in measure column

Hi Harsh, 

what do you mean by "There is a function in DAX for %ile calculation for expressions."? i thought that we had to create a table becuase the DAx required columens...hmm im more confused now.

look, i exported the data from the first table visual with some project selected and calculated the percentilexc in Excel and it doesnt fit..

i will keep checking.

thanks a lot

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