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


D column have loan number and bellow is count

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

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

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

      Thanks This one won't work bro 

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Have you checked my measure?

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!
         
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks For replaying still  coming count value not displaying loan number