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

[v-nmadadi-msft]

Hi @NandhiniNarasi 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @NandhiniNarasi 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi @NandhiniNarasi 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[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 · Accepted solution]

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