Creating new measure, only showing other measures

[KateDANI]

Hi

I need help please, I a fairly new to Power BI and just getting my head around creating measures, I thought I was getting somewhere as I have successfully created a couple of measures, but now when trying to create another one it will only let me select a previously selected measure and not any of the other columns, image below.

Please help

[Anonymous · Accepted solution]

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

[vicky_]

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]))