Forum Discussion

NadaBen's avatar
NadaBen
Helper I
9 years ago

make a trend based on two measures

Hello Team,

I need help to resolve my issue.

 

I want to make  a trend of a measure, so i calculated two measure :

- Measure 1: Taux de disponibilité catalogue élargi passé ; for current measure, based on table 1

-Measure 2 : Taux de disponibilité catalogue élargi futur : for projected meausres, based on table 2

 

Prob 1 : I want to assign my measure 1 exclusively for my current day which is : 7 mai ( the day in snapshot day of table 1), so that i cannot see this measure on my grapfic for other days. (see graphic)

 

Prob 2 : When i try to drag just common period day to axis, i can no longer see the evolution of my measure 2 in time (14-mai till 18 Juin) ( see graphic below)

 

Your help would be precious. Thanks in advance

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Could you create a third measure along the lines of:

     

    Measure 3 = IF([Snapshot.Day] = "7 mai", Measure1,Measure2)
    • NadaBen's avatar
      NadaBen
      Helper I

      I tried the formula, it doesn't work, now i have no graphic 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi NadaBen,

     

    Could you post the formulas for your measures you're using? It's better that you can also share a sample pbix file, so that we can better assist on this issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards

    • NadaBen's avatar
      NadaBen
      Helper I

      Hi v-ljerr-msft

      I made an excel sheet with samples of tables, meaures and calculated columns, and relations. I hope that i have been clear. I couldn't share the pbix, because the entire file is confidential, and the data model is too big so it wouldn't been clear enough to understand exactly what want.

       

      I'm very thankfull for your help because i'm really stuck for days .

       

      https://drive.google.com/drive/folders/0BwbSVJQB7uVJamFyWlJFc1M0aDA