DAX code for group by function

[Parihar1980]

How to write DAX code for the same 

* Flag_yes_no - Nvarchar value

Select Count(*), Flag_yes_no From table
Group by Flag_yes_no

[Eric_Zhang]

---

@Parihar1980 wrote:

How to write DAX code for the same 

* Flag_yes_no - Nvarchar value

Select Count(*), Flag_yes_no From table
Group by Flag_yes_no

---

@Parihar1980

You don't have to write any DAX, it could be as simple as below.

[Parihar1980]

I am using full table (all column ) for my model and there are other calculated column also using apart from this. So how can I take only Count(*) with Group by Column name only .

there should be some funcation for DAX isn't it ? plz help 

-----------------[Status of Initial Report] Pie Chart -------------
Select Count(([InitialReportSubmitted])) ,[InitialReportSubmitted] [Status]
FROM SIR.DWH.[Fact_NMAReportingStatisticsForSQPStates]
Group by [InitialReportSubmitted]

Expected result  ----------->>>>