Forum Discussion
Creating new measure, only showing other measures
Hi KateDANI ,
As checked your screenshot, what you are trying to create is a measure. And a measure cannot directly refer to a single value in a field (or column) of a table without using an aggregation function. This is because measures are designed to perform calculations on an entire set of data. A measure operates on a table as a whole because it aggregates data. For example, it can sum up all the values in a column or calculate the average. So, when you create a measure, you’re creating a calculation that will be applied to an entire column or set of data.
If you want to refer to a single value in a measure, you need to use an aggregation function that returns a single value. For example, the MAX, MIN or AVERAGE functions return a single value. You can also use the SELECTEDVALUE function, which returns the value of the specified column for the selected row.
Solved: Measure not recognizing columns - Microsoft Fabric Community
Best Regards
Hey,
the issue is that some functions require you to aggregate the columns you're working with. To see the other columns in the fill-in, you'll need to wrap a function like SUM(), or SELECTEDVALUE() around the column you're looking for -
e.g. DIVIDE(SUM(Table[ColumnA]), SUM(Table[ColumnB]))