PowerPivot Forum

Hi, Im triying to get the matrix shown in page 42, related to DistinctCount() customers by categories, but some thing I'm doing bad because when I put CalendarYears in columns, my figures in four years (2001 to 2004), are the same that Totals (18484), In other words, the four columns are equals than...

Hi Ramanav, To be much simpler, suppose you have 2 Look-Up tables and 1 Data table, all conected. The first Look-Up table has 3 columns A, B, C; the second Look-Up table has 3 columns D,E and F; and the Data Table has 3 columns A, D, G,(where G is "Sales" column). What I need is to create ...

Hi RamanaV Im using Database example of Matt's Book "Supercharge Power BI" [Total Sales] = SUM(Sales[ExtendedAmount] is a measure in "Sales" data table Customers and Products are lookup tables the name of data base is "AdventureWorks" and you can download it from: http/...

Hi Friends, I would appreciate your help to build a table with total sales for 4 disctinct colums from two different tables (Products and customers). For instance the following table: Categories Class Gender MaritalStatus [Total Sales] So, If There are 4 Categories, 4 Class, 2 MaritalStatus and 2 Ge...

Hi RamanaV

Depite the formula was correct, I eliminale it, I writte it again and the problem was solved. I don't know what happened
Very sorry and very thanks
Carlos

Hi friends, ¿is it posible that a PBI function doesnt work? Attached you will find the exercise of Supercharge Power BI, page 119: Nº 61- [Total Sales Month to Date] As you can see, figures of Total Sales MTD are equal to Total Sales!!! What I'm doing bad? The formula used seems OK : Total Sales Mon...