Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.