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.

[v-nmadadi-msft]

Hi @NandhiniNarasi  ,
Thanks for reaching out to the Microsoft fabric community forum.

First select any visual of your choice from visual pane

then Visual calculation will be available to use after selecting any visual of your choice ( not all visuals are supported for visual calculation)

Using Custom visual calculation you can run any DAX of your choice.

Please check this article to know more about visual calculation
Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
This will help you in converting DAX measures to Visual calculation

Also make a note that  visual calculations work within the confines of the visual matrix, functions that rely on model relationships such as USERELATIONSHIP, RELATED or RELATEDTABLE aren't available.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you