Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
007Raj
Frequent Visitor

filter working in Desktop, not working in service

Hello everyone

I am facing an issue, filter working completely fine in Desktop, not working in service

There is an error "cant display the visual." and following is the error description.  Kindly let me know if you need any further info in order to resolve the issue.

Activity ID: af886b97-86fc-40bf-83fe-4d757698ac47
Request ID: bcf0b6a5-d285-4e46-bf37-2f229dbca864
Correlation ID: e413f8ee-2af8-3b0f-9659-3b3b7bdceb83
Time: Tue Sep 20 2022 10:57:28 GMT+0300 (Arabian Standard Time)
Service version: 13.0.19087.45
Client version: 2209.2.13242-train
Cluster URI: https://wabi-west-europe-redirect.analysis.windows.net/

 

@amitchandak 

1 ACCEPTED SOLUTION
007Raj
Frequent Visitor

Hi everyone
thank you for your support.
The issue resolved on its own after 3 days (expected it to be much earlier)

I want to apprise to other developers that there is sometimes glitch from the backend (Microsoft's end) that some slicers does not work in power bi service but works fine in desktop and it was working fine earlier in service as well as desktop during testing and such glitches which does not require any intervention from developers but wastes a lot of time so be mindful of it.

Thank you

View solution in original post

9 REPLIES 9
007Raj
Frequent Visitor

Hi everyone
thank you for your support.
The issue resolved on its own after 3 days (expected it to be much earlier)

I want to apprise to other developers that there is sometimes glitch from the backend (Microsoft's end) that some slicers does not work in power bi service but works fine in desktop and it was working fine earlier in service as well as desktop during testing and such glitches which does not require any intervention from developers but wastes a lot of time so be mindful of it.

Thank you

v-xiaosun-msft
Community Support
Community Support

Hi @007Raj ,

 

I suggest that you can try the followings:

1, Check if the connection of dataset is correct. Because if it relates to Direct Query Mode, it will need an on-premises gateway connected correctly to show the visual.

2, Check the measure you created.

3, Try checking the memory, as not having enough memory will cause the visuals in the report to not display properly.

4, Try to swap for another visual to see whether it can be shown up.

 

Please refer to the following document:

Tips and tricks for creating reports in Power BI - Power BI | Microsoft Docs

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

007Raj
Frequent Visitor

Thanks @Greg_Deckler 

I had already raised issue 4 hours ago, did not receive any response from anyone, hence posted here

@007Raj So when you say the "filter is working/not working" are you referring to when you select something in a slicer, in the Filters pane or ? Also, what visual are you using? How is the visual configured?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

its a matrix visual which is giving error when sliced via a slicer

The visual is configured using disconnected table.  Column headings are fetched from disconnected table, rows are from another table, and switch statement is used to display values in the matrix.

@007Raj Sounds fairly innocuous. Mind sharing the measure formula? Maybe there is something there that is causing an issue.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Following is the dax:

P&L By Brand =


VAR _SalesCY = ROUND([Sales], 0)

VAR _GrossProfit = ROUND([Gross profit], 0)

VAR _NetProfit = ROUND([OprNetProfit], 0)

VAR _OperatingProfit = ROUND([Operating profit], 0)

VAR _StoreNetProfit = ROUND([Store net profit], 0)

VAR _SalesBud = round([Bud_Sales], 0)

VAR _GrossProfitBud = round([Bud_Gross Profit], 0)

VAR _NetProfitBud = ROUND([Bud_OprNetProfit], 0)

VAR _OperatingProfitBud = ROUND([Bud_Operating Profit], 0)

VAR _StoreNetProfitBud = ROUND([Bud_Store Net profit], 0)

VAR _SalesLY = ROUND([Sales LY],0)

VAR _GrossProfitLY = ROUND(CALCULATE([Gross profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _NetProfitLY = ROUND(CALCULATE([OprNetProfit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _OperatingProfitLY = ROUND(CALCULATE([Operating profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _StoreNetProfitLY = ROUND(CALCULATE([Store net profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _Result =

SWITCH (TRUE(),

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesCY, _SalesCY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfit,_GrossProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfit,_NetProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfit,_OperatingProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfit,_StoreNetProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_GrossProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_NetProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_OperatingProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_StoreNetProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),

 

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesBud, _SalesBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfitBud, _GrossProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfitBud, _NetProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfitBud, _OperatingProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfitBud, _StoreNetProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_GrossProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_NetProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_OperatingProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_StoreNetProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),

 

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesLY, _SalesLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfitLY, _GrossProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfitLY,_NetProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfitLY,_OperatingProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfitLY,_StoreNetProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_GrossProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type])
= "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_NetProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_OperatingProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_StoreNetProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK())
)

Return

_Result

following is the desktop setup

007Raj_0-1663742903710.png


following is the power bi service error:

007Raj_1-1663742935362.png

 



Following is the dax:

P&L By Brand =


VAR _SalesCY = ROUND([Sales], 0)

VAR _GrossProfit = ROUND([Gross profit], 0)

VAR _NetProfit = ROUND([OprNetProfit], 0)

VAR _OperatingProfit = ROUND([Operating profit], 0)

VAR _StoreNetProfit = ROUND([Store net profit], 0)

VAR _SalesBud = round([Bud_Sales], 0)

VAR _GrossProfitBud = round([Bud_Gross Profit], 0)

VAR _NetProfitBud = ROUND([Bud_OprNetProfit], 0)

VAR _OperatingProfitBud = ROUND([Bud_Operating Profit], 0)

VAR _StoreNetProfitBud = ROUND([Bud_Store Net profit], 0)

VAR _SalesLY = ROUND([Sales LY],0)

VAR _GrossProfitLY = ROUND(CALCULATE([Gross profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _NetProfitLY = ROUND(CALCULATE([OprNetProfit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _OperatingProfitLY = ROUND(CALCULATE([Operating profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _StoreNetProfitLY = ROUND(CALCULATE([Store net profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _Result =

SWITCH (TRUE(),

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesCY, _SalesCY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfit,_GrossProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfit,_NetProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfit,_OperatingProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfit,_StoreNetProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_GrossProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_NetProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_OperatingProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_StoreNetProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),

 

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesBud, _SalesBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfitBud, _GrossProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfitBud, _NetProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfitBud, _OperatingProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfitBud, _StoreNetProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_GrossProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_NetProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_OperatingProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_StoreNetProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),

 

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesLY, _SalesLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfitLY, _GrossProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfitLY,_NetProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfitLY,_OperatingProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfitLY,_StoreNetProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_GrossProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type])
= "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_NetProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_OperatingProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_StoreNetProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK())
)

Return

_Result

Following is desktop setup

007Raj_1-1663742387663.png

 

following is the power bi service error

007Raj_0-1663742335190.png

 

Greg_Deckler
Community Champion
Community Champion

@007Raj Only Microsoft speaks correlation IDs. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors