Forum Discussion
Quick measure for a "multivariable" variable
Hi, I have created a measure that can display different variables in the same view by clicking in a filter. However, I have had problems trying to create Quick Measures for this variable like Ave...
Hi Anonymous ,
I'd like to suggest you do unpivot column on query edit, then you can simply write formula to summary these values based on their category fields.
If you confused on coding formula, please share some sample data for test.
Regards,
Xiaoxin Sheng
That is exactly what I dont want to do. My table has more than 10 million rows and that would make it even bigger. I wanted a visualization where I could have all the variables together as you saw before in order to reduce the size of my table.
I wanted to know if I could apply the quick measure to that calculated measure or not. Could you create a formula/workaround?
Thanks in advance,
IC