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 SageThank you for directly sharing the PBI. This make it so easy for helping!
Do not forget to mark my solution, thank you 🙂
Try this
Measure 2 =
Do not forget to mark my solution, thank you 🙂
Try this
Measure 2 =
MAXX(FILTER('Table','Table'[close_dt]=BLANK()),'Table'[open_dt])
Measure 3 =
COUNTX(FILTER('Table','Table'[close_dt]=BLANK()),'Table'[open_dt])
newbie_powerbiHelper II
Helper IIsure, you have incorporated the logic of open inside the measure but my logic has mutiple conditions for open & my table has 10 millions rows
I just added a simple logic for the understanding
I need the same results using open ticket count measure
thank you
- andhiii079845
Than change it like this:
Measure 2 =MAXX(FILTER('Table','Table'[open ticket count]=1),'Table'[open_dt])- newbie_powerbi
ss
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.