Forum Discussion
anvikuttu
2 years agoAdvocate I
Dax Dynamic Measure
Hi Team, I have fact table and 2 dimension table called the months table. The months and the raw data are NOT connected to each other .Here I am trying to compare the month against the month. I...
- 2 years ago
Hi anvikuttu
Try to modify the way in which you use the EXCEPT function. I haven't tested the below but give it a go and modify to your needs:
New Fruits Flag = VAR SlicerMonth1 = SELECTEDVALUE( Month_Table_1[Month] ) VAR SlicerMonth2 = SELECTEDVALUE( Month_Table_2[Month] ) VAR FruitsInMonth1 = CALCULATETABLE ( VALUES( Raw_Data[Fruits] ) , Raw_Data[Month] = SlicerMonth1 ) VAR FruitsInMonth2 = CALCULATETABLE( VALUES( Raw_Data[Fruits] ) , Raw_Data[Month] = SlicerMonth2 ) VAR NewFruitsInMonth2 = EXCEPT ( FruitsInMonth2 , FruitsInMonth1 ) VAR CurrentFruit = SELECTEDVALUE ( Raw_Data[Fruits] ) RETURN IF ( CurrentFruit IN NewFruitsInMonth2 , "Yes", "No" )Make sure to place this measure in the visual where you have the fruits listed down and it should dynamically show "Yes" for new fruits in the selected comparison months.
Hoping this helps mate.
Theo