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

Thank you for u r replay 

 i am getting entire table  loan number count acutally  we want show count of loan number bellow itslef becasue if i count entire column its visble count values only right so clint need to show loan  number in column  and count in bellow table 

 

 

 

Thanks

mahi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

could you please give more details about expected output?

 

You want it in table or card?

 

if table then i have provided solution.

If card in card you can display only single measure value.

 

 

Thanks

Pravin

  • 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

     after using count mesure getting like 11--- and below 153 so we have to show loan number  and along with count