Calculation in a Column - with/without slicer

[Anonymous]

Hello,

I've seen  lots of similar new messages lately but couldn't find a solution to my problem.

Im gonna share three screenshots about the issue.

PB1 screenshot - column "% gerceklesen" simply calculates column "A" / column "B"

column "C" or "Ay" as the name seen there represents month;

PB2 screenshot - there i focus on visualization in gauge format, the one with % symbol. (%76,9 corresponds to month "ocak+subat" value.)  Months are in slicer with local names (turkish);

PB3 screenshot - there, in slicer no specific month selected, all values come with sum of relevant columns; in gauge, it seems %159,4, sum of first two rows. But i simply need the total sum column A / total sum column B as percentage, which should be %80,3

I hope it's clear enough.

 

Thanks,

Caglar

[MFelix · Accepted solution]

HI @Anonymous,

Create a measure that calculates both value and not a colum as you can see below it works fine:

Measure % Ger = DIVIDE(SUM(Sats[Total TEU Gerçekleçen]),SUM(Sats[Total TEU Hedeflenen]))

Regars,

MFelix

[Anonymous]

Thanks a lot! It worked like magic. As a beginner level power BI user, that was exciting to use measure 🙂