RANKX with Multiple Calculations

Anything related to PowerPivot and DAX Formuale
MikeTPMP
Posts: 1
Joined: Thu Dec 27, 2018 10:42 am

RANKX with Multiple Calculations

Postby MikeTPMP » Thu Dec 27, 2018 10:52 am

I have several fields that are calculated by getting a COUNT of TRUE or FALSE statements and divided by total number.

Example
1 FALSE
2 TRUE
3 TRUE
4 TRUE
5 TRUE

This would result in 80%.

I then have a calculated field that takes all of the percentages (as described above) and assigns them a number. I am trying to associate a RANK to that number.
I can create a RANK in Excel, however id like for this to be dynamic as the data is updated daily.

Additionally, all the calculated fields I mentioned above are coming from different tables with separate datasets. So I can not concatenate or append the data to each other to have one table.

Is there an efficient way of doing this?

Thanks in advance!

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests