Affichage champ par rapport à sélection segment

[scrat57]

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 ?

[v-yuta-msft]

@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:

 

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.

[scrat57]

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

[v-yuta-msft]

@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.

[scrat57]

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

[scrat57]

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