Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a TOPN Expression to pull the top row of a table based on the variance expression. I am wondering is there a way to display the BudgetMap[Budget Summary Line] Column for this value.
Solved! Go to Solution.
I figure it out. You need to use firstnonblank to pull the column name.
I wanted to edit this and make is more clear.
1st create a measure for the table with the rank you wish to use
Measure 1 =
I figure it out. You need to use firstnonblank to pull the column name.
I wanted to edit this and make is more clear.
1st create a measure for the table with the rank you wish to use
Measure 1 =
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |