topic Re: Consumo Medio Fixo in DAX Commands and Tips

Consumo Medio Fixo

carlosroston202 — Mon, 08 Sep 2025 19:08:12 GMT

Olá! Gostaria de uma ajuda com a medida Consumo Medio Fixo. Ela está exibindo a linha no gráfico para os meses que estão sem dados. Como posso ajustar esta medida de forma que não apareça a linha nos meses em que não esxitem dados?

Hello! I'd like some help with the Average Fixed Consumption metric. It's displaying a line on the graph for months with no data. How can I adjust this metric so that the line doesn't appear in months with no data?

Consumo Medio Fixo =

CALCULATE(

AVERAGEX(

SUMMARIZE(

'dCalendário',

'dCalendário'[Ano],

'dCalendário'[Mês]),

[Qtd Total]),

ALL('dCalendário'),

VALUES('dCalendário'[Ano])

)

Link do arquivo pbix:

https://drive.google.com/drive/folders/1YIuUa9X_AeTtxXaitQl-mjiy3NY0QF2j

Re: Consumo Medio Fixo

Jihwan_Kim — Tue, 09 Sep 2025 02:53:51 GMT

Hi,

Please try something like below.

Consumo Medio Fixo = IF ( [Qtd Total], CALCULATE ( AVERAGEX ( SUMMARIZE ( 'dCalendário', 'dCalendário'[Ano], 'dCalendário'[Mês] ), [Qtd Total] ), ALL ( 'dCalendário' ), VALUES ( 'dCalendário'[Ano] ) ) )

Re: Consumo Medio Fixo

carlosroston202 — Tue, 09 Sep 2025 11:52:05 GMT

Deu certo! Muito obrigado amigo.

Re: Consumo Medio Fixo

V-yubandi-msft — Tue, 09 Sep 2025 12:07:57 GMT

Hi carlosroston202 ,

Thanks for posting your query in the Microsoft Fabric Community. I've implemented the logic using a filtered average approach, and the output now reflects the behavior you described.

The Average Fixed Consumption line is displayed only for months where [Qtd Toatal] contains valid data, and it's automatically suppressed in months without entries keeping the visual clean and accurate.

For your reference, I've attached the PBIX file. Feel free to review it and let me know if you need any additional details or adjustments.

Thanks for your prompt response Jihwan_Kim .

Regards,
Yugandhar.