Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How to write Dax expression in Power BI tabular model . Please suggest
Select Count(*) , Year FROM [DBO].[Table] A
where UnitsReceived = 0
Group by Year
Solved! Go to Solution.
@Parihar1980 wrote:
How to write Dax expression in Power BI tabular model . Please suggest
Select Count(*) , Year FROM [DBO].[Table] A
where UnitsReceived = 0
Group by Year
Probably you may not need any DAX expression, as you can apply the SQL logic by using a slicer and a table visual.
Definitely you can create a calculated table with equivalent DAX.
Table 2 = SUMMARIZE ( ADDCOLUMNS ( FILTER ( 'Table', 'Table'[UnitsReceived] = "0" ), "Year", YEAR ( 'Table'[Date] ) ), [Year], "count", COUNTA ( 'Table'[UnitsReceived] ) )
@Parihar1980 wrote:
How to write Dax expression in Power BI tabular model . Please suggest
Select Count(*) , Year FROM [DBO].[Table] A
where UnitsReceived = 0
Group by Year
Probably you may not need any DAX expression, as you can apply the SQL logic by using a slicer and a table visual.
Definitely you can create a calculated table with equivalent DAX.
Table 2 = SUMMARIZE ( ADDCOLUMNS ( FILTER ( 'Table', 'Table'[UnitsReceived] = "0" ), "Year", YEAR ( 'Table'[Date] ) ), [Year], "count", COUNTA ( 'Table'[UnitsReceived] ) )
thanks a lot
thanks sir
But I am not sure when i am writing DAX code for this expression its not working
Select Count(*) ,[FLAG] FROM DimTable]
Group by [FLAG]
Kindly suggest
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |