I have several fields that are calculated by getting a COUNT of TRUE or FALSE statements and divided by total number.
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!
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests