Forum Discussion

arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

Fixed in power bi

HI,      I am very new to power bi. acutally i am trying to convert TABLEAU app into power bi.   in a chart there is caluclated dimension created as below   { FIXED [Year Week]: MAX([End Time])...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I believe what you want is:

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT([Year Week]))

My understanding of FIXED is that it in your case your formula will calculate MAX of [End Time] in the context of [Year Week] regardless of any other dimensions in the view.

 

The equivalent of that should be ALLEXCEPT in that ALLEXCEPT removes all context other than those specified in the function. 

arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

Thanks for the reply

 

by using this

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

 

i am getting only one value 

 

31/dec/2016

 

 

and above calcluation i am using as dimension.

 

can you check this

 

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi arulsettu,

     

    >>i am getting only one value 

    If you only drag this measure to a visual, you will get the max date. You can add other columns to work through this issue.

     

    Regards,

    Xiaoxin Sheng

    • arulsettu's avatar
      arulsettu
      Frequent Visitor
      9 years ago

      i am using this as dimension

       

      CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

       

      and 

       

      count(value)

       

      so where and what should i add as anew column

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi arulsettu,

         

        You should add a index column to let the measure calculate loop the table.

         

        For example:

         

         

        Notice: Count(value) will summarize this field

         

        Regards,

        Xiaoxin sheng