Count of values

[ashik1992]

Hi,

Thanks for the tips everyone.

I have one  doubt. i want to find the counts of status of projects from my table . table is like  this .

Projects	Proposal Status
p1	Accepted
p2	Accepted
p3	Accepted
p4	Accepted
p5	Accepted
p6	Accepted
p7	Accepted
p8	OnHold
p9	Rejected
p10	Accepted
p11	Not Proposing
p12	Accepted
p13	Accepted
p14	Accepted
p15	Accepted
p16	Accepted
p17	Accepted
p18	Accepted
p19	Accepted
p20	Accepted
p21	Lost
p22	null
p23	Accepted
p24	Accepted
p25	Accepted
p26	Accepted
p27	Accepted
p28	Accepted
p29	Accepted
p30	OnHold
p31	Accepted
p32	Not Proposing
p33	Accepted

What i want is ,the total number of accepted projects,Onhold projects like that . please hlp me

[ashik1992]

@Jihwan_Kim hello sir, this i wanted but when im applying the formula im getting diffrent count and but in the excel file count is correct 

[Jihwan_Kim]

Hi, @ashik1992 

Thank you for your feedback.

I am not sure how your data model looks like, but try to match all names in the DAX measure, including table name and column name.

Or, if you have another column in the table, perhaps that might affect.

if it is OK with you, please share your sample pbix file, then I can try to look into it and come up with a desirable solution.

Thank you.

[Arul]

@ashik1992 ,

Could you please share your results how it should be?

[Arul]

Hi @ashik1992 ,

Do you want to it as a measure?

[ashik1992]

yes

[Arul · Accepted solution]

Hi @ashik1992 ,

I hope this would help you, If not please let me know.

Thanks,

-Arul

[Jihwan_Kim]

Hi, @ashik1992 

Please correct me if I wrongly understood.

I guess you want to visualize like below, and if so, please try to create the below DAX measure.

Status Count =
IF (
     ISFILTERED ( 'Table'[Proposal Status] ),
     CALCULATE (
     COUNTROWS ( 'Table' ),
          FILTER (
          ALL ( 'Table' ),
          'Table'[Proposal Status] = SELECTEDVALUE ( 'Table'[Proposal Status] )
)
),
COUNTROWS ( 'Table' )
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!