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 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
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |