Forum Discussion
Sorting Multiple Text-Based Measures
Hi,
I have a series of measures that form KRI's calculated from my dataset. Each KRI is associated with a threshold, where if the threshold is not met, the measure returns blank. If the threshold is met, the measure returns with a text string including some calculations from the data.
I am looking to find a way to visualize all of the measures where the KRI threshold has been met (i.e., the measure does not return blank) in a single visualization, and exclude the blank measures. The visualization required would be similar to a text box with bulleted out strings for each KRI.
Is anyone aware of a method to exclude blank measures from a visualization entirely / dynamically exclude visualizations based on the output? A dynamic sort to push blank measures to the bottom of a visualization would also likely work.
Thanks!
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!
7 Replies
Exactly what I proposed 👍
I am using the Card (new) visualization with field parameters based on the type of KRI.
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
