Forum Discussion
Dynamically exclude blank values
Solution SageHi:
Can you send over example file?
Solution SageHi:
I made this file. I hope this is what you want. I broke it into a data model which will allow you to do more analysis and use a lot of pre-built in functions. For avg price, there is a test to determine if there is both a price and volume field [total Sales] so it excludes incomplete data.
https://drive.google.com/file/d/1wAFQbOHxkk7L-L4iH_RSJ61wYYJ4oFZX/view?usp=sharing
Hi and thanks for it.
But I think it's still not working properly. I need to compare every brand to Nivea, Nivea should be always 100%, I fixed this, I changed your All Brands measure to
"ALL Brands = CALCULATE([Avg Price], Products[Brand]="Nivea")"But then for the segment "Body" is still calculates wrong - because inside this segment there is only one product - Bodylotion 3 that both of the brands (Loreal & Nivea) have. The index should be 300/150=2 and not 1,43 ( I don't understand where 1,43 is coming from)BR
- Whitewater100
Hi:
I had explained there was both a brand index and a Loreal index. Maybe you did not see page 2?
I uploaded the second version prior to your reply. The brand index is a different type of index that I included, useful when you have partial data.
Anyways I created the Loreal versionthe index vs Loreal looks correct. Body Lotion 3 is 1 for Loreal, .5 for Nivea and .1 for the other brand, at $2 vs. $20, that looks correct.
The only thing strange is you don't seem to be seeing the latest version?
https://drive.google.com/file/d/1wAFQbOHxkk7L-L4iH_RSJ61wYYJ4oFZX/view?usp=sharing
Hi,
I downloaded the file only once and there was only page 1 in it, I'll have a look at the new file. Thank you.