cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaweher89
Helper I
Helper I

Sector and Geography granularity issue

I have a table Time

n1XPU.png

 

When the user selects period from february 2020 tç february 2021,I expect to get the following result

 

yBENC.png

 

But what I get

 

C7HHf.png

 

How to correct the issue with the granularity?

 

Here is the pbix file https://drive.google.com/file/d/1vf0khr7MbnDTVBzycNgJsaJufwd9F8D_/view?usp=drivesdk

1 ACCEPTED SOLUTION

@jaweher89 , Try

sumx(summarize(Table, Table[project Name], table[time]),[time])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

5 REPLIES 5
M_OVAISJANZEB
Helper IV
Helper IV

Hi @jaweher89,

just change the time value to Don't Summarize.

File: Link from Google Drive 

 

kindly accepts as Solutions

Resolve.png

I need to summarize value of time by project name regardless sector and geo. So it doesn't work. 

@jaweher89 according to your data. the total value is correct. if you share your excel file then I can guess which criteria you are summarizing. 

 

Resolve.png

@jaweher89 , Try

sumx(summarize(Table, Table[project Name], table[time]),[time])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

it's working. Resolve.png

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.