cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arulsettu Frequent Visitor
Frequent Visitor

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

 

 

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

 

7 REPLIES 7
Super User IV
Super User IV

Re: Fixed in power bi

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. 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

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

Community Support Team
Community Support Team

Re: Fixed in power bi

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

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

 

Highlighted
Community Support Team
Community Support Team

Re: Fixed in power bi

Hi @arulsettu,

 

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

 

For example:

 

Capture.PNGCapture2.PNG

 

Notice: Count(value) will summarize this field

 

Regards,

Xiaoxin sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

i am doinglike below is this correct

 

Thanks

Capture.JPG

richrider Occasional Visitor
Occasional Visitor

Re: Fixed in power bi

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


 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors