Forum Discussion
Re:Count issue
i have loan number column in table and client needs show table bellow in loan number count when ever i give count for loan number its reflecting entire column like bellow ex: loan number 12313...
Use a measure like one of the two
measure1 =if(isfilter(table[loan number]),max(table[loan number]),count(table[loan number]))
measure2 = if(isfilter(firstnonblank(table[loan number],blank()),max(table[loan number]),count(table[loan number]))
You might have try isinscope or hasonevalue in place of isfiltered
Refer:https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/