Forum Discussion
DAX help, countrows by rox context
Hello, I am currently fighting through a DAX problem and cannot seem to come up with a solution, see below screenshot as a reference. I have a table visualization, shown in step 1, where i'm disp...
Can you post that information as something that can be copied and pasted? Otherwise, we have to retype everything. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks Greg for that share, i will be sure to follow this from now on. please let me know if the repost still needs to be adjusted. i will also look at other post for examples.
I'm having a tough time following exactly what you are trying to do here. But, if you use the first table and you just want the count without the sub-events, make sure that the first column is Text and not numeric and then you can use this:
Event Count = VAR tmpTable = ALL(Wells) VAR tmpTable1 = ADDCOLUMNS(tmpTable,"Filter",VALUE(RIGHT([NPT RefNo],1))) RETURN COUNTROWS(FILTER(tmpTable1,[Filter]=0))
