Measure that includes only first entries in a time frame to calculations
Hi! I'm trying to calculate distinctcount from products tested in certain period of time. I got [SerialNumber]-column to identify exact product. I should count only those tests that are new for the time period (Test can fail and the same serial number will be tested again, but I don't want to count Re-tests). I'd like to find a Dax measure that checks when the first test of a serial number took place and excludes those from the count if they won't fit the time frame. I'm using separate calender table to get the time intelligence right. It's linked to [LocalDate]-column included in TestResults-table. TestResults-table is in import-mode if that helps with formulating the DAX. I've made the measure which returns corrct date for first entry of a serial number, but when filtering the visuals, It still counts those re-tests in. Picture below shows my problem. As you can see FirstPVM on the left says Serial number with 1000 is tested first time in 23.6. but still on the right side graph it still shows up on the 24.6 . Description on the right side says basically OK(re-tested) for the 1000 SN. Method for retrieving the first test date is following: FirstPVM = CALCULATE( FIRSTDATE(TestResults[LocalDate]); FILTERS(TestResults[SerialNumber]) ) Measure for counting all new products is following: AllTestedProducts = CALCULATE( DISTINCTCOUNT(TestResults[SerialNumber]); FILTER(TestResults;TestResults[LocalDate]=[FirstPVM]); FILTERS(TestResults[Team]) ) I'd like to modify it so the other dax measures won't calculate those serial numbers in which are first tested earlier than time frame (In example above before 24.6.). Also it should keep the original first date on FIrstPVM regardless slicer filtering. Only first tests of time frame should be counted. For example if I take last week, it should only count those serial numbers which has first entry in that week. I'm happy to answer your questions, because I'm not sure if this was clear enough 😄 Thanks for help in advance!capacity planning for power bi report server (PBRS) import (cached) mode
Hello everybody. If i understand, the document Capacity planning guidance for Power BI Report Server (PBRS) https://powerbi.microsoft.com/en-us/documentation/reportserver-capacity-planning/ address aspects for Live/DirectQuery connection capacity planning - when the analytical queries itself are being executed on external analytical system (SSAS). In a case of Cached data PBRS handles analytical workload internally - any ideas how to estimate the hardware in this case?
