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