distinct count

Hi. I just started playing with DAX formulas and Power Pivot. I would appreciate any hints on how to do the following: There is a list of stores (green table) with a sales value for a date. I added this table to the data model and created a Power Pivot. Using the measure: Months by...

Hi Everyone, so I need a way I can count the number for employess that worked for each week. I have two columns of data Column C is the week start date (i.e 18/09/2017) Column J has the names of the employee loggen for that lines sale. I'm trying to count how many different employees sold...

Hi below is my formula for counting the number of transactions. But the issue is I now need to know the NET number of transactions. So if i had 16 sales and 2 returns the total I need is 14 transactions not 18. TRANS# DISTINCT COUNT:=DISTINCTCOUNT('SALES TABLE'[TRANS#]) Can anyone help with...

In Excel 2013 and 2016 there is the option to select "Add this data to the Data Model" when creating a Pivot Table. This will allow for summarize values by "distinct count" (finally!) I did not check the box when I made my Pivot Tables. However, I need the "distinct count" function and I do not...

Hi All, this is my first post. I am very new to PowerPivot and I want to recreate a calculation that I have in my normal pivot table in power pivot. Lets say I have 2 columns; Column 1: UserName, Column 2: Date. I want a PivotTable/Chart with Distinct New users by date (who have visited my...

I have the code to create a pivot table from my data set however I'm not sure how to include the data in the data model (which is an option you see when clicking on "PivotTable" from the Insert Tab. My goal is to have a Distinct Count of my variable that I'm using in the Values data field...

Hi Folks, The scenario is that I have a data set consisting of basically a sales history log, and need to show the stage of each sale by week, looking back in retrospect. The data consists of every sale, which we'll call opportunities, each having its own unique 18char id. Each record in this...

Hi, I'm trying to perform a distinct count of an attribute of my data. I'm using a pivot table as a view on a PostgreSQL server with data in star schema. In 100% excel (where the data is in the same file) I can simply apply a pivot table and select the option to "add this data to the Data...

I've been stuck on this for a while now and would great appreciate any input you may have on this. I have a table with two values, Region and 'Start Date'. What I would like to do is get a count of all distinct combinations within a specified date range. I have 2 tables below, one to show an...

I'm a PowerPivot newbie and once again I'm stuck in the very basics of using the PowerBI. Here's my table setup: Table fSales has fields like StoreID, ProductID, Payment Method and Sales Amount. It's joined to TbStores with the StoreID, tbProducts with the ProductID and tbPAymentMethods...

Hi guys, I'm completely fogged here and don't know where to begin. I have a table that I need to know a subtotal based on each order. Hopefully I can describe this correctly. Of the table below what I need as an output is the Order Number and how many distinct load numbers there are to each...

I have a power pivot set it to show values as Distinct count, a welcome new feature in Excel 2013 ;) I want to show these as a percentage but my issue is that if I set the values to % of grand total, the total of all my rows add up to about 140%. I assume it is showing the Distinct count % of...