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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
scrat57
Frequent Visitor

Affichage champ par rapport à sélection segment

Bonjour,

 

J'ai un champ qui a une valeur par semaine.

J'ai un segment qui me permet de choisir les semaines que j'affiche.

 

Je voudrais récupérer la valeur du champ pour la dernière semaine sélectionnée. Si je force dans mon calcul le nom de la semaine cela fonctionne (

Objectif DCR dernière semaine = calculate(MAX('Objectifs Delta Parc Fibre'[Objectif DCR]);Calendrier[Semaine]="S47")
 
J'arrive également afficher ma dernière semaine sélectionnée par :
Dernière semaine = max(Calendrier[Semaine])
 
Par contre impossible d'incorporer cela dans la première formule pour rendre cela automatique.
 
Une idée ?
 
Semaine.JPG
5 REPLIES 5
v-yuta-msft
Community Support
Community Support

@scrat57 ,

 

So Dernière semaine and Objectif DCR dernière semaine are two different measures, right? If you need to achieve two different aggregation values, I'm afriad you couldn't combine the two measures. 

 

As a workaround, you can drag the two measures to a multi-row visual as below:

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

No, it is not 2 measures but 2 fields in 2 relatd table. I don't only want to show them but calculate other meausres with the Objectif DCR of the last week

 

 

@scrat57 ,

 

So they're two calculated field, right? And your requirement is to use these two calculated field in other measures, right? Could you show the other measures you mentioned and clarify the expected result? If possible, please share some sample data.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

It is 2 shields (not calculated) and related by the day date

 

Semaine.JPGobjetcif.JPG

i want to create a measure who give me the "Objectif DCR" of the maximum "Semaine" selected in the segment

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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