cancel
Showing results 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.

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 ?

5 REPLIES 5
Community Support

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.

Frequent Visitor

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

Community Support

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.

Frequent Visitor

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

Frequent Visitor

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

Announcements

#### 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

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors