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

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.