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!