Need to Convert Complex DAX into New visual calculation

[NandhiniNarasi]

I have a report which is done by an existing power bi developer and it takes much time to load the report. There are so much of complex DAX formulas which are there. I wanted to convert thse dax into simple visual calculations and i dont have knowledge in visual calculations. How can i achieve this? I have 100's of DAX formulas like this. Kindly help.

Ex:

Est GrossProfit % = DIVIDE([$ Sales True GP OE], ROUND([$ Net OE], 4))

// VAR MaxPeriod = IF(HASONEVALUE(PeriodPPP[PERIOD]), SELECTEDVALUE(PeriodPPP[PERIOD]), MAX ( PeriodPPP[PERIOD] ) )

// VAR InvoicedOrders =

//     CALCULATETABLE(

//         OSBG,

//         FinCalendar[FinYearMonthOrdinal] <= VALUE(MaxPeriod),

//         OSBG[OEFlag] in {"B", "P", "R", "F"}

//     )

// VAR Result =

//     CALCULATE(

//         DIVIDE([$ Sales True GP OE], [$ Net OE]),

//         FinCalendar[FinYearMonthOrdinal] <= VALUE(MaxPeriod)

//     )

// RETURN

//     Result

[Demert]

Hi @NandhiniNarasi ,

could you give more info about what you are trying to achieve. Currently when I look at the dax measure it's only 1 line of code which references 2 other measures where we don't know if those measures are optimized. All the other lines are commented out (//). If you visuals are loading slow, there can be many different factors to it. A lot of measures inside the visuals, many data to process, not optimized dax code....

[NandhiniNarasi]

Hi Thanks for your quick response. Actually i have a report and as you said its loading very slow and there are so much of DAX calculations in the report. Now my TL has asked me to convert it as a paginated report and add visual calcualtions in it, to improve the performance of the report. but im not sure how to do that.