Forum Discussion

odiogorodrig96's avatar
odiogorodrig96
New Member
3 years ago

PowerBI Desktop - Measure repeating itself for each column

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.

5 Replies