Forum Discussion
Helper ISorting Multiple Text-Based Measures
Okay, thank you for the reply! I was able to find a workaround solution. I created a new table with a column "KRI" with values 1 through 8 (I have 8 KRI's). In this table I used a switch measure titled Indicator to call the measure values according to their priority rank in the KRI table.
In the measure DAX, instead of resulting in blank I changed the output to 0 if the criteria is not being met. I then input the KRI and Indicator columns into a table, and put a filter on the table to where Indicator does not equal 0, and then sorted based on the KRI priority.
Thanks again!
Hello jtooke,
I didn't fully understand how you did it.
Can you show how you new table looks like?
How you related the measure with the new table?
And how the measure would look like?
I have a simillar problem with a multiple row cards.
Which i have to change the measures according with the selected month.
Thanks
Helper IHi EmanuelVBT,
To solve this problem, I entered a table with one column (called "a"), and values in each row corresponding to the number of measures needed. I have 20 measures so I entered values from 1 through 20. I used numbers in this column because I wanted to set a priority ranking on the KRI's for importance, but this column can include whatever you want (i.e., KRI names, etc.).
I then added a measure off of this table with the below formula. The numbers 1-20 correspond to the rows in my table, and the measure is the associated measure to that row. I then visualized with a matrix. Wherever the measure came back 0, the row is filtered out from the matrix and the rows are sorted based on the priority column.