I have a question in Power BI, I'm a DBA and I'm growing my bank with the following formula:
YoY = CALCULATE(('Consulta2'[AVAILABLE_SPACE] - 'Consulta2'[TOTAL_SIZE]/'Consulta2'[TOTAL_SIZE]))
But he is returning this message:
A single value could not be determined for the
'AVAILABLE_SPACE'column in the'Consulta2'table.
This can happen when a measurement formula refers to a column that contains many values, without specifying an aggregation, such as min , max , count , or sum to get a single result. p>
Could anyone help me?