I find myself a bit stuck on perhaps two simple task.
I have a PBI that needs to do two things:
Task 1 -
- Make a measure that can be added to any column, that will do this…
- Sum all values >=4,
- then divide by total rows
Task 2 -
- Use the SupportFile as a support table
- Group the columns from the Results file by the criterial form the SupportTable file.
For example, all columns from 1-3 in Results file will be grouped in “Overview” because they match with the “Sort” column in SupportTable file.
Any type of support will be greatly appreciated.
Sample.zip (68.6 KB)