Forum Discussion

khallar's avatar
khallar
Regular Visitor
4 years ago

Measure not adjusting correctly to filter context

Hi all, I want to calculate historic savings considering inflation. I managed to do it by product by year, but it breaks when I add any other parameter like country or more than one product. I have t...
Need Help
khallar's avatar
khallar
Regular Visitor
4 years ago

Example of what Im saying
Product A

 


Product B

 


Product A and B together not working

I need something that calculates this line by line as shown, but then be able to aggregate by year with all products, by category and by client. Any help appreciated, thanks!

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi khallar ,

Firstly please check that in the Values ​​pane of the visual, Quantity has sum selected.

If that doesn't work, from now on, I need to reproduce your problem to know what the cause is. So more information is needed.

According to your description, there are two tables: FACTS and DateKey. In the FACTS table, there are two columns: Quantity and Unit Cost USD. In the DateKey table, there are three columns: Date, CPI Index and Year.

How does the two tables relate to each other, and which table does the Product in, and what's the relationship with other table. 

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.