Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mac2
New Member

Calculate measure with unique value from another table

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

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @Mac2 

try like:

Measure2=
VAR _days =
MINX(
    FILTER(
        ALL(AnotherTable),
        AnotherTable[Term] = MAX(Table1[Term])
    ),
    AnotherTable[Days]
)
RETURN
DIVIDE([measure], _days)

View solution in original post

2 REPLIES 2
Mac2
New Member

Thank you so much for your help. Much appricated! 😊

FreemanZ
Super User
Super User

hi @Mac2 

try like:

Measure2=
VAR _days =
MINX(
    FILTER(
        ALL(AnotherTable),
        AnotherTable[Term] = MAX(Table1[Term])
    ),
    AnotherTable[Days]
)
RETURN
DIVIDE([measure], _days)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.