Forum Discussion
Multiplying Column by Measure not Working
Hello,
I am having an issue that seems like it should be a really simple fix but it is not...at least for me.
I created a measure, "PercentDif", to calculate the percent difference between a revenue column and an adjusted revenue measure (which is simply the sum of the revenue column minus a few hard-coded adjustment values). That percent difference comes out to 0.03. I then have a matrix table that displays revenue by month and what I want to do is create another measure, "Rev Adj", to multiple the revenue column by PercentDif for each month but this is where I run into issues.
When I do that, for each month row, the entire year's revenue is multiplied by the percent difference, not that individual month's revenue. So, I have a resulting matrix that shows the entire year's revenue multiplied by PercentDif in each month's row. However, the confusing part about this is that if I change the "Rev Adj" measure from multiplying the revenue column by PercentDif to multiplying the revenue column by the actual 0.03 percent difference value (not referencing the PercentDif measure) it works completely fine. So, I do not understand how/why referencing the measure doesn't work but when I hardcode in the measure's result it works completely fine. Since revenue will change month to month I need the percent difference to be dynamic and therefore I need to reference the PercentDif measure, I cant just use its value.
I am at a complete loss and any help would be greatly appreciated!
Thanks!
1 Reply
- amitchandakSuper User
jerickson0001 , if you trying to use measure in column that is not going to work. In a measure, you can multiply or do the operation with another measure or aggregated column . Hard coded to static values can also be used in measure
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.