Measure to show % of shop type product is sold in when filtered by product
Trying to write a measure where if i filter by a product it gives me what % of that store type the product is sold in, my data looks like so with this kind of being the output (or at least i can pull the measure into a table and calculate/count it etc)
Calculate Value to GAP Price
Hi team, I need your help to calculate "GAP PRICE", this is divide the Price Value of one column value between the another value from same column A column has 2 values: "Company 1" and "Company 2" Each Product has an Unit Price in each Company GAP_Price Product 1 = Unit Price (product 1 in Company 1) / Unit Price (product 1 in Company 2)
DAX measure does not return the same value more than 1 time
Hey everyone, So, the problem is that a fairly simple measure does not return a value twice or more if the value of 'Measure 1' is same: MFR = DIVIDE ( SELECTEDVALUE('Table'[FR]), 12 ) As you can see, after returning 8 once, it doesn't do anything until it gets 9, then 10. There are three 10 values, and it returns only one of them. Same issue with other values. How do I fix it so it could return values?Table Filter not working when using measure
Hi everyone, when I am using the following measure: LM Change = SWITCH( TRUE(), ISBLANK([LM CY]) && ISBLANK([LM PY]), blank(), DIVIDE( [LM CY], [LM PY], "" )-1 ) I get the following table that outlines last month sales of the current year, it's corresponding sales in the previous year and the percentage change between these two figures per account: However, when I would like to split each account sales by country by dragging it in the rows-section of the visual, it says Can anyone please help me understand and solve this error? Thank you in advance!
