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
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
        Could you please tell us what is expected output with some example.

        What do you mean by loan number along with count.

        Thanks
        Pravin