Fixed in power bi

[arulsettu]

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])}

Year Week is year and week from a date field

so to do this power bi i did as follows

Year Week = FORMAT([end_time].[Date],"yyyy")&WEEKNUM([end_time].[Date],2)  ---> in text format

And for { FIXED [Year Week]: MAX([End Time])} i did below

CALCULATE(MAX([end_time].[Date]),ALL(Year Week))   ---->date format

but not getting the output

can anyone help me on this

[Anonymous]

Hi, 
I'm very new to tableau, 
I'm migrated this form of tableau for Power BI 

in a collum of table there is calculated dimension created as below

Vda Forn Cat
{ FIXED [Regiao IM], [Nome Fabricante], [Nome Categoria], [Mercado] : SUM([Vendas Valor])}

so to do this power bi i did as follows:

Metrics = CALCULATE([Vendas Valor Cat]; ALLEXCEPT(DIM_CATEGORIA_AGREG;DIM_CATEGORIA_AGREG[REGIAO_IM];DIM_CATEGORIA_AGREG[NOME_FABRICANTE];DIM_CATEGORIA_AGREG[NOME_CATEGORIA];DIM_CATEGORIA_AGREG[MERCADO]))

[Greg_Deckler]

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]

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]

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]

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]

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

[arulsettu]

i am doinglike below is this correct

Thanks