## Search found 26 matches

Tue Oct 03, 2017 8:48 pm
Forum: PowerPivot/DAX
Topic: current and prior 3 quarters have sales>0
Replies: 1
Views: 1257

### current and prior 3 quarters have sales>0

I am trying to write a DAX measure which counts number of rows where current and prior 3 quarters have sales>0. In the attached PBIX file you will see a table in Report page. What I want is for row 1 the test measure should return value of 1, row 2 should have value of 2, row 3 should have value of ...
Tue Jul 25, 2017 2:41 pm
Forum: PowerPivot/DAX
Topic: Calculate with a double-column filter [Solved]
Replies: 5
Views: 2939

### Re: Calculate with a double-column filter[Solved]

Use the sample data your provided, let's call first table as Day, second as Growth, you can use below to add the required calculated column in Day table
Total for each day = CALCULATE(SUM(Growth[Growth]),RELATEDTABLE(Growth)).

sample workbook also attached
Tue Jul 25, 2017 10:09 am
Forum: Power BI Desktop/Service
Topic: Row Level Security
Replies: 1
Views: 1749

### Re: Row Level Security

I think the best way to go is have a mapping table sitting in between your fact and vendor table.
Tue Jul 25, 2017 10:02 am
Forum: PowerPivot/DAX
Topic: Calculate with a double-column filter [Solved]
Replies: 5
Views: 2939

### Re: Calculate with a double-column filter[Solved]

It's good to have more info on what you are trying to achieve. Also it's even better if you can send a screenshot of expected results. Working out the DAX code shouldn't be too hard
Wed Jan 06, 2016 12:39 pm
Forum: PowerPivot/DAX
Topic: why first 3 days returns 2 instead of 1
Replies: 6
Views: 3013

### Re: why first 3 days returns 2 instead of 1

Hi XLBOB & Matt, My reading of your formula is "How many dates in the entire date table, when 1 is subtracted from the month, appear in the current date filter context?" It turns out that when 1/4/09 and 29/3/09 have 1 subtracted from their month, the result in both cases is 1/3/09 (s...
Wed Jan 06, 2016 7:13 am
Forum: PowerPivot/DAX
Topic: why first 3 days returns 2 instead of 1
Replies: 6
Views: 3013

### Re: why first 3 days returns 2 instead of 1

No,the dates table is not missing any single date. It's the formula which gives me 2for the highlighted cells. I am trying to understand how
Tue Jan 05, 2016 9:54 pm
Forum: PowerPivot/DAX
Topic: why first 3 days returns 2 instead of 1
Replies: 6
Views: 3013

### Re: why first 3 days returns 2 instead of 1

Just add to my previous comment. the data model sitting behind is simple, just one date table with dates from 1 Jan 09 to 31 Jan 11
Tue Jan 05, 2016 9:52 pm
Forum: PowerPivot/DAX
Topic: why first 3 days returns 2 instead of 1
Replies: 6
Views: 3013

### why first 3 days returns 2 instead of 1

I have attached a screenshot. the formula for the calculated field is above the pivot table. Can someone tell me why this formula returns 2 for the first 3 days of Mar 2009?
Tue Jan 05, 2016 2:18 pm
Forum: PowerPivot/DAX
Topic: question on RANKX
Replies: 7
Views: 3793

### Re: question on RANKX

Yes, it's me. we met at PUG meeting. Thanks for your reply. I have managed to come up with a solution using Calculate and Allexcept, same logic as your nested filter. What I am trying to achieve in the end is to have 5 pie charts for the top 5 category, then for each pie chart, it has 6 pieces for t...
Sun Jan 03, 2016 9:48 pm
Forum: PowerPivot/DAX
Topic: question on RANKX
Replies: 7
Views: 3793

### Re: question on RANKX

Hi Matt, my situation is not the same as Michael's. I need to achieve ranking and assign a new group as I will use those rankings and new group in Pivot Table