Forum Discussion

SimonM's avatar
SimonM
Regular Visitor
10 years ago

How do I return a calculated table sorted by a specific column?

Hi there, I'm fairly new to DAX and I have a simple question I can't seem to find an answer to.  In the image below I am adding a percentage column to a table in Power BI Desktop,  What is the syntax...
Need Help
ALeef's avatar
ALeef
Resolver II
10 years ago

I think it would need to look like:

 

Table 3 = SAMPLE(10,TableTest,[Motivated]/[Base], DESC)  

 

So you are sorting by the expression, instead of the static column.  You could also try:

 

Table 3 = SAMPLE(1,TableTest,MAX(TableTest[Percentage], DESC)  

SimonM's avatar
SimonM
Regular Visitor
10 years ago

Hi ALeef

Thanks for the examples, my results based on your suggestions are below. So -  example 1 is still not sorting, despite doing the calculation in the SAMPLE function.

 

 

Table3.JPG

 

Also, example 2 is showing some strange behaviour, even though I put 5 in the first value of SAMPLE, it returns the whole 10 rows (and again, not sorting!). I would have thought it would have returned 5 rows?  I still need to try your Distinct Count solution on the Sector rather than a Group By so will do that over the weekend.

SampleExample.JPG

Thanks

Simon