Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a measure that I am using in a matrix as show below:
HT1 HT2 HT3 HT4 HT5
A 32 34 30 31 33
B 30 31 33 32 31
C 28 25 29 32 30
I have another table
Term Days
HT1 34
HT2 39
HT3 33
HT4 35
HT5 36
I am trying to write a measure that perform a division eg
HT1 HT2 HT3 HT4 HT5
A 32/34 34/39 30/33 31/35 33/36
B 30/34 31/39 33/33 32/35 31/36
C 28/34 25 /39 29/33 32/35 30/36
How can I write this measures? I also need to multiply these number by 100 to work out the percentage.
Thanks in Advance
Mac2
Solved! Go to Solution.
hi @Mac2
try like:
Measure2=
VAR _days =
MINX(
FILTER(
ALL(AnotherTable),
AnotherTable[Term] = MAX(Table1[Term])
),
AnotherTable[Days]
)
RETURN
DIVIDE([measure], _days)
Thank you so much for your help. Much appricated! 😊
hi @Mac2
try like:
Measure2=
VAR _days =
MINX(
FILTER(
ALL(AnotherTable),
AnotherTable[Term] = MAX(Table1[Term])
),
AnotherTable[Days]
)
RETURN
DIVIDE([measure], _days)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |