Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Complex Dax Query Help

Hello,   I am making my first attempt at a complex Dax query to produce a table of results. I've hit a few bumps a long the way and progress was mostly promising, but I've hit a wall. I'm trying to...
DAX Performace
DAX Query
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
4 years ago

Hi Anonymous 

 

You may try to use this part to finish your dax query.

// Find the rank at the 95th percentile of all ranks for each product/station

var table _ThresholdRank =

               ADDCOLUMNS(

               FILTER(_RankedUsage,

               [ReverseRank] == 1),

               "ThresholdRank", roundup([Rank]*0.95, 0)

               )

              

// **Missing Step** - Create a list of Period Usage for each product/Station where the rank = the 95%ile rank above             

Return SUMX(table_ThresholdRank,[ThresholdRank])

                                                                          

EVALUATE

 

Best Regards,

Community Support Team _ Caiyun

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let us know. Thanks a lot!