The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi All,
Please can you help in converting this MDX Calculated Measure to DAX Calculated Measure:
MDX:
SELECT
non empty{([Measures].[Gross Usage Revenue])} ON COLUMNS ,
non empty
{
(
[Country].[Country Code].[Country Code],
[Service Type].[Service Type].[Service Type],
[Call Type].[Category].[Category],
[Call Type].[Sub Category].[Sub Category],
[Telecom Area].[Telecom Area].[Telecom Area],
[Telecom Area].[Telecom Operator Name].[Telecom Operator Name],
[Event Direction].[Event Direction Code].[Event Direction Code],
[Product].[Product ID].[Product ID]
)
}
ON ROWS
FROM [Model]
where
{
[Calendar].[Date].&[2022-10-01T00:00:00]
}