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
amitchandak's avatar
amitchandak
Super User
6 years ago

Use a measure like one of the two

measure1 =if(isfilter(table[loan number]),max(table[loan number]),count(table[loan number]))
measure2 = if(isfilter(firstnonblank(table[loan number],blank()),max(table[loan number]),count(table[loan number]))

 

You might have try isinscope or hasonevalue in place of isfiltered

Refer:https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

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

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