Re:Count issue

[Anonymous]

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 

[amitchandak]

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/

[Anonymous]

Thank you for u r replay 

 i am getting entire table  loan number count acutally  we want show count of loan number bellow itslef becasue if i count entire column its visble count values only right so clint need to show loan  number in column  and count in bellow table 

Thanks

mahi

[Anonymous]

could you please give more details about expected output?

You want it in table or card?

if table then i have provided solution.

If card in card you can display only single measure value.

Thanks

Pravin

[Anonymous]

 after using count mesure getting like 11--- and below 153 so we have to show loan number  and along with count

[Anonymous]

D column have loan number and bellow is count

[v-kelly-msft]

Hi @Anonymous ,

You need a measure as below:

Measure = IF(HASONEVALUE('Table'[Consumption])=TRUE(),SUM('Table'[Consumption]),COUNT('Table'[Consumption]))

Then you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Thanks For replaying still  coming count value not displaying loan number 

[Anonymous]

Try this

@Anonymous 

Total count=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.

[Anonymous]

Thanks This one won't work bro 

[v-kelly-msft]

Hi @Anonymous ,

Have you checked my measure?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Could you please tell us what is expected output with some example.

What do you mean by loan number along with count.

Thanks
Pravin

[Anonymous]

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.

[Anonymous]

Thank you for replay 

if i use card bellow table u can get it but if u scroll left side and right side its always difficult right

he wants show 

loan number

12133

12323

12323

count 3 like this 

if i use coult entire table count that always unacceptable right 

[Anonymous]

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.

[Anonymous]

loan number not shoing its showing count actually can u try it sampel excel file and send screeen shot 

Thank you in Advance

Mahi

[Anonymous]

In card it will show only count not loan number.

For table you have to drag loan number and then count measure. it will show 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.