distinctcount

Hi, Can someone please help me with the syntax to find the average of a measure using DISTINCTCOUNT. Here is the syntax of my measure: Number of Units = DISTINCTCOUNT( LoggedInData[Unit_ID] ) I was hoping I could just do something like this: Avg Number of Units =...

Hello, I am attempting to use the DistinctCount expression to determine the number of properties (Serial Numbers in the attached spreadsheet) that are contributing to an aggregated column. The properties all start on day 1 but turn off at different times, therefore leaving the aggregated column...

Hi, I have a TMOV table containing DATE and PRODUCT columns, among other columns, that is related with a TDATE table containing DATE and YEAR_MONTH columns. I would like to populate an additional column in the TMOV table with DISTINCTCOUNT of YEAR_MONTHS by PRODUCT, i.e. number of months that...

I have a table that lists States and Cities. I need a measure that counts how many distinct cities exist for each state. As an example. Say there are 500 cities in CA and 10 Cities in NV. My result should look like Los Angeles 500 San Diego 500 Las Vegas 10 Reno 10...

Hi All, I have excel 2010 and have power pivot installed. I'm trying to get the distinct count of the product code per group but not able to. When I try distinctcount I get the error This is not a valid DAX expression. Not sure if distinctcount is available with the powerpivot for excel 2010...

Hi, I have a fact table with CustomerNo, DateKey, ProductKey, SupplierKey, Sales. This is related to a Calendar table, Product, and Supplier Table. I'm trying to calculate a distinct count of customer where the sales = 0 in a specific year and keeping the original filter conditions on related...