User Profile
Henrykong_
Resolver I
Joined 4 years ago
User Widgets
Contributions
Re: Bar chart X-axsis is not changing according to the filters
Hi Tarunika , For this type of problem, see if the measure formula created removes the filtering context corresponding to the external date slicer. when change date in slicer, no reflect Amount_filter_slicer = CALCULATE ( SUM ( FactInternetSales[SalesAmount] ), ALL ( DimDate[FiscalYear] ) ) If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply. Best Regards, Henry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Re: How to copy value in measure to calculated column
Hi PowerVisualBI , There is a difference between measure and calculated column, and it is not possible to convert the formula directly between the two. For measure: Calculated using all of the filters: Contextual Filtering. Isn’t saved and isn’t calculated ahead of time. When you put it on a report page and alter a slicer, filter, or tap on a column chart or any other visual to highlight and it affects this measure’s value, it’s computed on the go. Calculation uses the CPU. For calculated column: Calculation by row: Row Context Retained in memory (consumes RAM) Computed at the time the report is refreshed (either scheduled basis or manual) Common conversion steps are referenced below:(convert a measure to a calculated column in Power BI) Step 1: Pick the measure column that you want to convert into a calculated column (do not tick the checkbox to include the column in the sheet; only select the column). Step 2: In the “Default Summarization” selection, any aggregation will be applied by default. Step 3: From the drop-down menu, choose “Do Not Summarize.” For more details, you can read related blog: Calculated Column and Measure in Power BI (powerbiconsulting.com) Best Regards, Henry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Re: Calculated column not filtering matrix using a measure as a value when I collapse rows
Hi mpml , I am unable to reproduce this problem for the time being. Can you provide the relevant test data so that I can do further testing? How to Get Your Question Answered Quickly - Microsoft Power BI Community Looking forward to your reply. Best Regards, HenryRe: Power BI Report Server Web Service URL is not working - it just browses my reports
Hi PaulineSP , Does Oracle ODAC client allow access to this url, or is the address incorrectly filled in? Can you provide more screenshot information such as the relevant operation section so that I can do further testing. Looking forward to your reply. Best Regards, HenryRe: SAP reports to PowerBI
Hi Anonymous , For now, Microsoft has developed SAP BW Connector Implementation 2.0. you can choose between SAP BW Connector Version 1 or SAP Connector Implementation 2.0. For more details, you can refer to the related documentation below. Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Docs If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply. Best Regards, Henry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Re: Previous rows value based on date (Lag functionality from SQL in Power BI logic)
Hi Anonymous , You can try formula like below: M_Pre = VAR pre_ = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) - 1 ) ) RETURN CALCULATE ( MAX ( 'Table'[Volumn] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] = pre_ ) ) If converted into a calculated column formula, you can use the top function to get the value of any of the first few lines (or summation). Specific reference to the following formula: Column = VAR pre_row = TOPN ( 1, FILTER ( 'Table', 'Table'[Month] < EARLIER ( 'Table'[Month] ) && 'Table'[Employee] = EARLIER ( 'Table'[Employee] ) ), [Month], DESC ) VAR pre_val = MINX ( pre_row, [Sales] ) RETURN 'Table'[Sales] + pre_val If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply. Best Regards, Henry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Re: Conditional formatting progress check Matrix
Hi EmkaAZWRK , Whether the advice given by amitchandak has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Looking forward to your feedback. Best Regards, HenryRe: SnowFlake Connection
Hi mhassan3 , The first thing you should install the ODBC Drivers. After installed the 64bit drivers where your power BI Desktop installed, and also installed it on all the Servers where your the On-Premise Data gateway installed. Below is the link that you can download Snowflake Repository (snowflakecomputing.com) Note that only the ODBC driver needs to be installed and there is no need to do any configuration of the ODBC driver, this is because it will be configured in Power BI Desktop. For more details, you can read below blog: Snowflake + Power BI If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply. Best Regards, Henry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
