Report Server connection string error
Using MSSQL as the database and the authentication as Windows Authentication everywhere. Also have the SSAS Service running in the SQL Configuration Manager. When running the Power BI report server, the structure of the dashboard is displayed but the data is not able to load and none of the visualizations are displayed. The dashboard is working fine with Power BI Desktop RS version. The data source connection is working while testing. Tried configuring the connection string from the database with but still the same error persists ReplyForward Add reaction
Question: I want PowerBi to report to me only the diversity (distinct) groups of each phase.
Question: I want PowerBi to report to me only the diversity (distinct) groups of each phase. Background: During my evaluation, I did a series of interviews over two phases (conduct and scoping) as show by the data table below. Problem: When I slice for 'conduct phase', I want it to report a list of only the DISTINCT/diversity of groups interviewed, which would be: LPL TYT GTG If I slice for 'scoping phase', I want it to show the DISTINCT/diversity of groups as: MRL GTG What I have tried: I have used the following DAX to create a second table (UniqueL1Table) of these distinct groups, and have it shown as a list, but it can only show as all diversity of both Conduct and Scoping groups....even if I slice for only conduct, it will still show as: LPL TYT GTG MRL UniqueL1Table = Distinct('Combined Tables'[L1]) Data used: Group Phase LPL Conduct Phase TYT Conduct Phase GTG Conduct Phase GTG Conduct Phase MRL Scoping Phase GTG Scoping Phase GTG Scoping Phase
Summarize table Lookupvalue in Funnel Visual
Hi Everyone, i have the below summarized table "Cover Type Analysis" as per the below : CoverTypeAnalysis = SUMMARIZE('Production ReportV20-V1 Power B','Production ReportV20-V1 Power B'[Cover Type],'Production ReportV20-V1 Power B'[Transaction Year],"Total Premium",SUM('Production ReportV20-V1 Power B'[Cedent Premium])) i have created a new column LastYear: LastYear = IFERROR(FORMAT(CoverTypeAnalysis[Transaction Year],"General Number") - 1,0) i need to calculate PercentageYearlyGrowthByCoverType: PercentageYearlyGrowthByCoverType = DIVIDE(CoverTypeAnalysis[Total Premium] - LOOKUPVALUE(CoverTypeAnalysis[Total Premium],CoverTypeAnalysis[Transaction Year],CoverTypeAnalysis[LastYear], CoverTypeAnalysis[Cover Type],CoverTypeAnalysis[Cover Type]), ABS(LOOKUPVALUE(CoverTypeAnalysis[Total Premium], CoverTypeAnalysis[Transaction Year],CoverTypeAnalysis[LastYear], CoverTypeAnalysis[Cover Type],CoverTypeAnalysis[Cover Type])))/100 i have Transaction Year a Slicer Filter = 2019, everything looks wonderfull and the Funnel is looking correct: I was asked after that to add Quarter and Month Filters to this report, i added them to the summarized table : CoverTypeAnalysis = SUMMARIZE('Production ReportV20-V1 Power B', 'Production ReportV20-V1 Power B'[Cover Type], 'Production ReportV20-V1 Power B'[Transaction Year], 'Production ReportV20-V1 Power B'[Transaction Quarter], 'Production ReportV20-V1 Power B'[Transaction Month], "Total Premium",SUM('Production ReportV20-V1 Power B'[Cedent Premium])) and adjusted PercentageYearlyGrowthByCoverType to be as per the below: PercentageYearlyGrowthByCoverType = DIVIDE(CoverTypeAnalysis[Total Premium] - LOOKUPVALUE(CoverTypeAnalysis[Total Premium], CoverTypeAnalysis[Transaction Year],CoverTypeAnalysis[LastYear], CoverTypeAnalysis[Transaction Quarter],CoverTypeAnalysis[Transaction Quarter], CoverTypeAnalysis[Transaction Month],CoverTypeAnalysis[Transaction Month], CoverTypeAnalysis[Cover Type],CoverTypeAnalysis[Cover Type]), ABS(LOOKUPVALUE(CoverTypeAnalysis[Total Premium], CoverTypeAnalysis[Transaction Year],CoverTypeAnalysis[LastYear], CoverTypeAnalysis[Transaction Quarter],CoverTypeAnalysis[Transaction Quarter], CoverTypeAnalysis[Transaction Month],CoverTypeAnalysis[Transaction Month], CoverTypeAnalysis[Cover Type],CoverTypeAnalysis[Cover Type])))/100 however im getting wrong results as if it excecute the formula for each row and at the it sums all percentages while what i want is to make the calculation for all selected values: also i tried to create a mesure but it returned empty and couldnt load it into Funnel Visual PercentageYearlyGrowthByCoverType mesure = DIVIDE(SUM(CoverTypeAnalysis[Total Premium]) - LOOKUPVALUE(CoverTypeAnalysis[Total Premium], CoverTypeAnalysis[Transaction Year],SELECTEDVALUE(CoverTypeAnalysis[LastYear]), CoverTypeAnalysis[Transaction Quarter],SELECTEDVALUE(CoverTypeAnalysis[Transaction Quarter]), CoverTypeAnalysis[Transaction Month],SELECTEDVALUE(CoverTypeAnalysis[Transaction Month]), CoverTypeAnalysis[Cover Type],SELECTEDVALUE(CoverTypeAnalysis[Cover Type])), ABS(LOOKUPVALUE(CoverTypeAnalysis[Total Premium], CoverTypeAnalysis[Transaction Year],SELECTEDVALUE(CoverTypeAnalysis[LastYear]), CoverTypeAnalysis[Transaction Quarter],SELECTEDVALUE(CoverTypeAnalysis[Transaction Quarter]), CoverTypeAnalysis[Transaction Month],SELECTEDVALUE(CoverTypeAnalysis[Transaction Month]), CoverTypeAnalysis[Cover Type],SELECTEDVALUE(CoverTypeAnalysis[Cover Type]))))/100 appreciate your urgent assistance Thank you in advance Best regards, Georges Sabbagh
Prior row value and Percentage change for non-sequential indexed rows
Dear all, I am new to using dax and was wondering if you could help. In the report below I was trying to calculate the % change where the report is from multiple table sources. The data is in a way so there are multiple dates from each underlying table, hence I just used the month number to remove the issue of showing multiple lines as the sale value is a calculation based on the totals for the month. In this, I was trying to calculate the % change based on the prior row. I have seen many examples of this where a clear date/month / year, is straightforward, although I was trying to do this based on the Line ref (as shown below). The calculations are as follows: LineRef = min ('Date'[Ref] ) Prior row value = CALCULATE ( [Net Sales], Dateadd( 'Date'[Date] , -1 , MONTH )) % Change = DIVIDE( ( [Net Sales] - [Prior row value]) , [Prior row value] ) RankRef = RANK.EQ ([LineRef] , 'Date'[Ref] , ASC ) Although I was struggling to get the Prior row value and % change to work due to the LineRef not being sequential, therefore I could not use current row less one etc to calculate the prior row. The issue is the multiple dates to use Dateadd . I also tried to use rankx to get a sequential number but that did not work. The idea being if Rankx worked I could pick up the prior row based on current rank less 1. I was wondering if there was a way to get the above to work, and needed your help with a solution that may work in this situation?
Return previous Month Balances from Running Data
I am trying to receive the last month's value for each row here. They all belong to the same item. However, I am only getting some previous monthly values in return, and I am not quite sure why. Here is the variable and DAX command used. Any answer to why only some are returning a value?
Need steps to develop custom visuals as per requirement and able to see in report server(version 1.1
Hi Powerbi developers, PowerBI I want a get some knowledge from this channel . How to degrade custom visuals in vs code with api version and visual tools version supports report server version 1.11 How to check the compatibility versions to develop custom visuals Please share any source code links or blogs or youtube links Please my request as priority and hoping to get more replies. Any Suggestion should be appreciated. Thanks in advance, Bhanu Sri
