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

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'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.