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)
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!
