Forum Discussion
Display minimum value on every row under group
Since making this calculation off the measures I already have doesn't work, I decided to create a new table in my DB then create calculated columns to get the answers I needed. Not ideal, but it works.
Thanks everyone for your input.
I'm not sure how to do this if these are all measures.
1] Assuming you can create a dynamic table with the fields SKU, Size, etc.
I have created a normal data table from data file for demo.
2] I created a measure on this table for the NewSize%
3] Dynamically create another table using the table in step#1 and added a new column for Minimum Size%
I understand still the 4M rows performance impact will apply, but putting this forward as a thought.
Hope this helps.
Since making this calculation off the measures I already have doesn't work, I decided to create a new table in my DB then create calculated columns to get the answers I needed. Not ideal, but it works.
Thanks everyone for your input.