Forum Discussion
newbie_powerbi
Helper II
Helper IIsumx and allselected
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/ I can see that iteration on allselected creates a shadow context I use ALLSELECTED inside SUMX so how can I handle my probl...
andhiii079845
Solution Sage
Solution SageThan change it like this:
Measure 2 =
MAXX(FILTER('Table','Table'[open ticket count]=1),'Table'[open_dt])
newbie_powerbiHelper II
Helper IIss
placed the measure but it is returning the same value as open_dt
- andhiii079845
You can not but open_dt and close_dt in this matrix. look to my matrix.
- andhiii079845
Make a matrix in excel and show us what you want to see 1:1 🙂
- newbie_powerbi
can you share the pbix file
I replaced the same measure as you sent but got the max date as open_dt
- andhiii079845
You mentionied this, what you want zu see (yellow):
I send you this: (measure definition in my previous post)
You build this:
Delete the columns open_dt and close_dt in your matrix. 🙂
Than you get the yellow marked rows. If you want something else please make a little example in excel what do you want to see excatly.