Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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
You don't have to write any DAX, it could be as simple as below.
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 ----------->>>>
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |