PowerPivot Forum

Effectively yes there is a crossjoin. The job of the relationship is to propagate filters from the one side to the many side. When you place 2 columns from 2 separate source tables in a visual, it creates a crossjoin and then filters out the relationships that don't exists (because of filter propaga...

You can probably do it in DAX, but how about you take a look at my video showing how you could do this in Power Query. https://www.youtube.com/watch?v=xN2IRXQ2CvI

In this post, I will share with you the errors noticed after the book is published. Chapter 17 Here’s How: Creating a Morphing Switch Measure In the definition of the measure [Measure to Display], the measure [Selected Measure] is given as [Selected Value]. Chapter 15 Writing Custom Time Intelligenc...

In this post, I will share with you the errors noticed after the book is published. Chapter 17 Here’s How: Creating a Morphing Switch Measure In the definition of the measure [Measure to Display], the measure [Selected Measure] is given as [Selected Value]. Chapter 15 Writing Custom Time Intelligenc...

You could join it to the description. It sounds to me like your data is unstructured, and you need some structure to it if you want to go down this path.

Ok, so this is not really a job for power pivot. This sounds like master data to me. There should be a one time creation of the key words for each product. You need a lookup table of all the products, and a data table of the product codes and key words, like this. Product table ID. Desc 1 Red Apple ...

Ok, thanks. I see this as a data preparation task, better for power query rather than power pivot. You say each time text contains “one” keyword. Is it really 1 only, or can there be more than 1? It makes a difference.

Are you using 32 or 64 bit office? You could try Power BI 64 bit and see if that helps. Sorry, I can’t think of anything else.

This doesn’t sound like a DAX task, but maybe a power query task. The general pattern is to optimise and prepare your data before loading to power pivot rather than trying to solve such issues in DAX. Can you give a more detailed description of the problem you are trying to solve? Or you could use t...

Hi YettyB. I assume you mean Learn to Write DAX. This book is 30 months old, and no one has every pointed this out to me :shock: This was fixed in my new edition, but obviously doesn’t solve this problem. The sentence refers to the table above, not below, and the “red” is the “box” drawn on the pivo...