topic Re: ProductX for Measure not Working in DAX Commands and Tips

ProductX for Measure not Working

quickcreator — Tue, 04 Feb 2020 18:51:21 GMT

I have 2 tables, cash & assets. I made a measure: (current months’s assets – current month’s cash)/previous month’s assets. It gives me a % return, which is great. However, I’m trying to get a running return by month but nothing is working. I’ve tried the ProductX on this % measure, but it comes up blank. I’ve also tried the Calc(ProductX…Filter(…<=Max, but it grabs everything from the beginning up to my slicer value. I just need a value for a specific date range. Any ideas how to get ProductX to work on this measure?

Re: ProductX for Measure not Working

AlB — Tue, 04 Feb 2020 19:59:03 GMT

Hi quickcreator

Can you please share an example based on data, so that it is easier to understand what you are after? Ideally, share a mock pbix

Cheers

Re: ProductX for Measure not Working

quickcreator — Wed, 05 Feb 2020 00:46:03 GMT

Here's the screen shots. Let me know if this makes sense. Thanks so much for your help!

Re: ProductX for Measure not Working

quickcreator — Wed, 05 Feb 2020 01:21:31 GMT

Re: ProductX for Measure not Working

Anonymous — Wed, 05 Feb 2020 01:38:35 GMT

Who do u means by productx measure.

Whenever you ask question on community please share some sample data and expected output.

Thanks,
Pravin

Re: ProductX for Measure not Working

quickcreator — Wed, 05 Feb 2020 01:51:11 GMT

Hi Pravan. The pic & DAX is posted as a pic above. Thanks for your help!

Re: ProductX for Measure not Working

Anonymous — Wed, 05 Feb 2020 08:57:08 GMT

try this,

i think % return should be column so that the formula will work.

Calculate(productx(table,1+table[rate%]),filter(all(table),table [date]< max(table[date]))

Thanks,

Pravin

Re: ProductX for Measure not Working

quickcreator — Wed, 05 Feb 2020 13:24:36 GMT

Thanks, but it %Return is not a column. It is a measure based on filtering from the Cash & Assets table. I need a ProductX based on a Measure, please. Thanks for your continued investigation on this.

Re: ProductX for Measure not Working

Anonymous — Wed, 05 Feb 2020 13:42:25 GMT

Try this,

MEasure=

Var table=Summerize(table1,date,"rate",[Rate %])

return

Calculate(productx(table,1+[rate]),filter(all(table),[date]< max([date]))

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Re: ProductX for Measure not Working

quickcreator — Wed, 05 Feb 2020 15:22:56 GMT

Thanks, but I don't have a fixed Table. I have a resulting dynamic matrix from the combination of the Cash & Assets table, then it is filtered by Investment & Date. Thanks for trying.

Re: ProductX for Measure not Working

BrenoPin — Fri, 13 May 2022 13:36:07 GMT

Hello, I am trying to do something similar, did you find a solution?

Re: ProductX for Measure not Working

quickcreator — Fri, 13 May 2022 14:24:16 GMT

What in particular are you trying to solve?

Re: ProductX for Measure not Working

Brenoo — Fri, 29 Jul 2022 13:41:15 GMT

A PRODUCTX from a measure. Samething from your problem I have a measure that return me the Rate% and need to do a ProductX from that Rate%. How did you solve your problem?