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

 

6 REPLIES 6
Super User
Super User

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

Highlighted
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, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
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

 

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, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

i am doinglike below is this correct

 

Thanks

Capture.JPG

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 398 members 3,785 guests
Please welcome our newest community members: