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