cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DYY94
Helper I
Helper I

Lookup measure from table to another table

Hello Community, 

 

How can i get a mesaure from table to another table.

- This my measure [MR/365]:  

 

MR.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

- This my first Table "Output_Maturite"

 

Capture 12.PNG

- This the new table "Maturite Modifier" i have created to get other fields: 

 

Capture 8.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now the probleme is when i get the measure [MR/365] from "Output_Maturite" to "Maturite Modifier" table is always gave me '1' for all columns. 

 

This is [MR/365]: 

 

MR/365 = IF( [Maturité Résiduelle] / 365 <1,1,[Maturité Résiduelle] / 365) 

 

This is Maturité Résiduelle:

 

Maturité Résiduelle= DATEDIFF(SELECTCOLUMNS(TC,"xx",SELECTEDVALUE(TC[Situation])),SELECTCOLUMNS(Output,"s",Output[Maturite]) ,DAY)

 

 

Here a simplified file to understand more the issue.

https://drive.google.com/file/d/1Y2eAmjcVyWDJozOTxEaNFXh3F9ZeNpmu/view?usp=sharing

 

Thanks.

2 REPLIES 2
amitchandak
Super User
Super User

@DYY94 , A calculated table can not take slicer values, which means the calculation would be static and some measure calculations may not work as expected



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Hi @amitchandak , 

 

Thanks for your reply ! 

 

do you have any other idea to do that ? i'm really stuck 

 

Thanks. 

 

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors