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
12313
12313
output:
loan number
1
1
1
like this coming so client does'nt accepting this
client need bellw like this:
loan number
12333
12323
12323
count: 3
so please help
16 Replies
if you want to display count in card use below dax
Measure=Count(table[laon number])
If you want it in table along with loan number then use below dax
measure=Calculate(count(table[Loan number]),all(table))
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.In power bi table visual ,
if you are using this loan number it will automatically remove duplicates and shows single entry of value even if there are multiple values exist.
then create simple measure
measure=count(Table[Laon number])
and drag this in table visual.
You will have your loan number along with count.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
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/
