Forum Discussion

Joerobert's avatar
Joerobert
Advocate V
8 years ago

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...
Need Help
Joerobert's avatar
Joerobert
Advocate V
8 years ago

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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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))