Search found 1099 matches

by MattAllington
Tue Jul 07, 2020 8:25 am
Forum: PowerPivot/DAX
Topic: Excel PowerPivot Many-to-One reference
Replies: 6
Views: 97

Re: Excel PowerPivot Many-to-One reference

2 things. 1. Your measure is stored in the wrong table - that is what is causing the false positive warning. 2. I missed a bracket in my formula (sorry about that). When you added it, you put it in the wrong place. This is the correct formula =Sumx(Price_table,CALCULATE(Sum(Quantity_table[Quantity])...
by MattAllington
Tue Jul 07, 2020 7:22 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Total year today
Replies: 1
Views: 62

Re: Total year today

Can you share your workbook here?
by MattAllington
Mon Jul 06, 2020 9:56 pm
Forum: PowerPivot/DAX
Topic: Excel PowerPivot Many-to-One reference
Replies: 6
Views: 97

Re: Excel PowerPivot Many-to-One reference

Please share your workbook.
by MattAllington
Sun Jul 05, 2020 12:06 pm
Forum: PowerPivot/DAX
Topic: Function are not color coded green and measures are not added automaticaly
Replies: 1
Views: 32

Re: Function are not color coded green and measures are not added automaticaly

There are 2 Separate dialogue boxes to write measures in Power Pivot. The one you are using doesn’t have the features. Instead of right clicking on the table and selecting “add measure”, go to power pivot, measures, new measure. Then it will do what you have described.
by MattAllington
Sun Jul 05, 2020 12:04 pm
Forum: PowerPivot/DAX
Topic: DAX Measure: Sum specific column from all Identical Tables
Replies: 1
Views: 63

Re: DAX Measure: Sum specific column from all Identical Tables

You should use power query to load all the sales data from all the tables into one single table before loading into power pivot. You can use “get file, from folder” to do this automatically.
by MattAllington
Sun Jul 05, 2020 11:37 am
Forum: PowerPivot/DAX
Topic: Excel PowerPivot Many-to-One reference
Replies: 6
Views: 97

Re: Excel PowerPivot Many-to-One reference

Firstly I assume you have correctly created the relationship. Secondly, I assume you have used the product from the qty table Instead of the price table. This is causing the warning. You should hide the column on the many side of the relationship and use the column from the one side. Then you can wr...
by MattAllington
Sun Jun 07, 2020 7:54 am
Forum: PowerPivot/DAX
Topic: Dependent slicers
Replies: 3
Views: 361

Re: Dependent slicers

If you are using PowerPivot for Excel, this should be automatic.
by MattAllington
Thu Jun 04, 2020 5:11 pm
Forum: Power Query
Topic: Power Query - load connection to pivot table not available
Replies: 1
Views: 332

Re: Power Query - load connection to pivot table not available

There should be a flag “add to data model”. Select connection, and “add to data model”. Then insert a pivot table after that.
by MattAllington
Wed May 27, 2020 5:35 pm
Forum: PowerPivot/DAX
Topic: Problem with filtering a 0 value
Replies: 2
Views: 234

Re: Problem with filtering a 0 value

If the first filter is 0, then it will return zero. I think you will find that the first filter may return null, which is not shown by default. If you want to return zero when a null is returned, simply add 0 to the measure

Eg divide(top,bottom) +0
by MattAllington
Sun May 24, 2020 7:45 am
Forum: PowerPivot/DAX
Topic: Referencing Measures within CALCULATE() & FILTER()
Replies: 1
Views: 174

Re: Referencing Measures within CALCULATE() & FILTER()

It’s complicated. The 2 formulas are not the same, even though they look the same. The first one is actually = CALCULATE( COUNTROWS(Sales), FILTER( Products, Products[ListPrice] = CALCULATE(MAX( Products[ListPrice] )) ) ) A measure contains an implicit calculate which forces context transition when ...

Go to advanced search