## Search found 52 matches

Fri Apr 14, 2017 3:19 pm
Forum: PowerPivot/DAX
Topic: Filter a table of calculated measures [Solved]
Replies: 8
Views: 2785

### Re: Filter a table of calculated measures[Solved]

There are a number of Pcodes that have equal populations and when using the Rankx function you may need to use the "Skip" or "Dense" switch. I used "Skip", it seems to return a more accurate running total. However, you will have Pcodes that have identical percentiles.
Fri Apr 14, 2017 2:05 pm
Forum: PowerPivot/DAX
Topic: Filter a table of calculated measures [Solved]
Replies: 8
Views: 2785

### Re: Filter a table of calculated measures[Solved]

I don't know how you do it... I hadn't even considered that approach.

Here's the Post codes and populations. This is the old (2011) census data, the 2016 data will be out later this year.
Fri Apr 14, 2017 11:58 am
Forum: PowerPivot/DAX
Topic: Filter a table of calculated measures [Solved]
Replies: 8
Views: 2785

### Re: Filter a table of calculated measures[Solved]

Yes, BTW, I got around this by exporting the postcodes and populations to excel and hard coded the cumulative percentage in. However, I could do that because there are only 2,467 post codes. :) . The population data by post code can be downloaded from the ABS web site. I've only extracted to Post Co...
Tue Apr 11, 2017 4:14 pm
Forum: PowerPivot/DAX
Topic: Filter a table of calculated measures [Solved]
Replies: 8
Views: 2785

### Filter a table of calculated measures[Solved]

I have a table which shows Post code and population. I've created calculated measures which rank the Population in descending order, A cumulative total of population based upon Rank, and calculated the percentage the cumulative total is of the Total Population. For an idea of what the DAX equations ...
Tue Apr 11, 2017 2:35 pm
Forum: Power BI Desktop/Service
Replies: 1
Views: 1134

for anyone that may be interested, this is not possible to do in Linkedin.
Tue Apr 11, 2017 2:34 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Running Totals to Dispaly Inventory Position Over time
Replies: 1
Views: 1275

### Re: Running Totals to Dispaly Inventory Position Over time

I'm not sure if this will help as i'm new to DAX as well but, May I test terminology please? 1. On Hand means Finished Inventory available for Sale at the start of the day (Carry in Value)? 2. Sales Order decrements finished inventory on that day? 3. In Cure would be WIP, and not part of Finished Go...
Tue Mar 21, 2017 12:05 pm
Forum: Power BI Desktop/Service
Replies: 1
Views: 1134

Has anyone tried posting an Iframe link into a Linkedin discussion. All I can get is a hyperlink which opens a Power BI App outside of Linkedin. I was hoping to embed the Iframe so people could interact with it in the post.
Fri Feb 24, 2017 2:33 pm
Forum: PowerPivot/DAX
Topic: Aggregation is not adding up?
Replies: 4
Views: 1924

### Re: Aggregation is not adding up?

Here's the solution that worked. Much thanks to Matt for the direction and to Ulrik Moller who showed me how to use the Summarize function. Promotional Unit Sales = SUMX ( SUMMARIZE ( 'Fireneeds x Week Data', 'Fireneeds x Week Data'[Date], 'Fireneeds x Week Data'[State], 'Fireneeds x Week Data'[Acco...
Mon Feb 20, 2017 8:34 am
Forum: PowerPivot/DAX
Topic: Aggregation is not adding up?
Replies: 4
Views: 1924

### Re: Aggregation is not adding up?

Thanks Matt, I have seen the Summarize command and was wondering how/why it would be used. I'll give it a try and post back with the result. Matt, during my search for a solution I was reading about the Calculatetable function and was wondering what the difference was between it and Calculate... apa...
Mon Feb 13, 2017 2:54 pm
Forum: PowerPivot/DAX
Topic: Calculate delta for mothergroup as sum of delta members
Replies: 1
Views: 851

### Re: Calculate delta for mothergroup as sum of delta members

Hi Ovlovsky, I'm not an expert but, to me this sounds like the solution might by using the SUMX function. I think a formula like below may be start; Total Delta = sumx('Table_name", Abs([forecas] - [Order]). From what I understand of the sumx is the function forces the calculation to iterate th...