Re: PowerBI Desktop - Measure repeating itself for each column

odiogorodrig96 — Thu, 11 May 2023 10:01:07 GMT

hello my friend, I've watched the video and it didnt work for me. Is there any other approach you would recomend?

PowerBI Desktop - Measure repeating itself for each column

odiogorodrig96 — Wed, 10 May 2023 14:34:06 GMT

Hello! I've recently just started working with PowerBi and I've been having an issue which I would like some help if you may.

In the image above as you can see I have a field named Deviation which is a Measure that basically calculates the difference between the values on Financial (Sum of Value) - Contractual(Sum of Value). E.g: 4.299.121,55 - 4.862.594,49 = -563.472,94.

The Measure is setted like this:

Deviation = CALCULATE(SUM('project-consolidated-metrics'[Value]), 'project-consolidated-metrics'[projectBaselineType]="FINANCIAL", REMOVEFILTERS('project-consolidated-metrics'[version],'project-consolidated-metrics'[dateCreated]),All('project-consolidated-metrics'[projectBaselineType]))-CALCULATE(SUM('project-consolidated-metrics'[Value]), 'project-consolidated-metrics'[projectBaselineType]="CONTRACTUAL",REMOVEFILTERS('project-consolidated-metrics'[version],'project-consolidated-metrics'[dateCreated]),All('project-consolidated-metrics'[projectBaselineType]))

My problem is that I want this Measure named Deviation to only appear once as a column, instead of repeating itself for each column (CONTRATUAL, FINANCIAL,MANAGEMENT).

Can anyone help? I'm quite a rookie on powerbi currently so if you could explain it in a simple way I would be very much aprecciated.

odiogorodrig96 Tracker

Re: PowerBI Desktop - Measure repeating itself for each column

PowerBI Desktop - Measure repeating itself for each column