Forum Discussion
Calculation in a Column - with/without slicer
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
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
2 Replies
- MFelix
Super User
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