Achieve the dynamic field calculation in Power BI using DAX

[harrypotter]

I have a MDX query that needs to be converted in DAX in Power BI. MDX:

CASE WHEN ISEMPTY( [Measures].[Total] )
THEN NULL ELSE IIF(ISEMPTY( Axis(1).Item(0).Item(0).Dimension.Levels(0).item(0)),1,[Measures].[Total] / (Axis(1).Item(0).Item (0).Dimension.Levels(0).item(0), [Measures].[Total] )) ENDTotal / (The Total of the entire columnar data)

I assume that the above query is: Total is Aggregated sum of the data as per month or any dimension and % Total is:

Total / (The Total of the entire columnar data)

Please see the below screenshot (Sample data) :

Please help me achieve the above functionality in Power BI. Thanks in advanced.

[v-yuezhe-msft · Accepted solution]

@harrypotter,

Please create a new column using the DAX below and check if you get expected result.

Total % = if(ISBLANK(SampleData[Total]),BLANK(),SampleData[Total]/sum(SampleData[Total]))

Regards,
Lydia

[harrypotter]

Thanks Lydia for the solution! 🙂