Search found 3 matches

by CarbonChauvinist
Wed Jun 21, 2017 5:46 am
Forum: PowerPivot/DAX
Topic: Modifying Query Context with ALL()?
Replies: 5
Views: 228

Re: Modifying Query Context with ALL()?

Thanks for the help and time Matt, I do appreciate it. Based on your clues I was able to get the following to work for my needs: Sales Days:=CALCULATE(DISTINCTCOUNT('fPSGSales'[creation_date])) Number of Sales Days in Year := IF ( HASONEFILTER ( 'dCalendar'[ps...
by CarbonChauvinist
Sat Jun 17, 2017 3:15 am
Forum: PowerPivot/DAX
Topic: Modifying Query Context with ALL()?
Replies: 5
Views: 228

Re: Modifying Query Context with ALL()?

Wow, thanks so much for the helpful reply Matt; very much appreciated! I'll definitely take to heart your best practice recommendations re: table naming conventions moving forward, thanks again. I also watched both videos in your link, and will be re-watching the one dealing with evaluation context ...
by CarbonChauvinist
Thu Jun 15, 2017 6:57 am
Forum: PowerPivot/DAX
Topic: Modifying Query Context with ALL()?
Replies: 5
Views: 228

Modifying Query Context with ALL()?

I’ve been tasked with putting together a report that lists the top N sales days in a given time period which I’ve been able to do successfully. This is a simple report with only two tables, the fact sales table (fSales) and a calendar table (dCalendar) (see attached screen grab for reference). fsale...

Go to advanced search