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
TheoC
2 years agoCommunity Champion
Hi anvikuttu
Are you able to send me the sample data you're working with (or the PBIX file)?
Also, I just realised that the Month1 and Month2 tables are not necessarily structured in a particular order of month (i.e. Month1 = Feb, Jan, Mar & Month2 the same).
Let me know if it's possible to send through the data!
Thanks heaps,
Theo