Matrix visual show two columns as Total and % total along with other columns
I have a matrix visual shows the country as rows, segments as column and the grandtotal. I need to add one more column beside total as total %. I dont need to add % for all the segments only as a column beside grandtotal. Below is the visual I need to add % as a seperate column as a last column in the matrix. If I create a measure and add it, it is adding for all segments I dont need that to all the segments. I need both total and % columns at the end. Can anyone help on this or any suggestion or workaround? Thanks Sri
Help with measure
I am trying to calculate the volume/Sales at plant level. Example below , so the total volume sold for AM Sports Depot reppeats in each line for sales plant column the example above uses this formula listed below:- Sales Plant = CALCULATE( SUM(STG_INVENTORY_PROGRESSION[Volume Sold]), ALLEXCEPT( STG_INVENTORY_PROGRESSION, STG_INVENTORY_PROGRESSION[COMPANY_NAME], STG_INVENTORY_PROGRESSION[REGION_NAME], STG_INVENTORY_PROGRESSION[PLANT],STG_INVENTORY_PROGRESSION[YEAR_MONTH] ) ) I am Trying to create a measure which would give similar results. the new formula I am trying to recreate is given below:- here geography name in the above formula = Plant in the below Sales Plant = CALCULATE( [Ticket Volume Delivered Qty], ALLEXCEPT('1 - Company', '1 - Company'[Company Name]), ALLEXCEPT('3 - Geography', '3 - Geography'[Geography Region Name], '3 - Geography'[Geography Name]), ALLEXCEPT('Date', 'Date'[Year/Month Name Short]) ) but the results I am getting with the second formula are as below. I want the value 722897.68 for Sales plant for AM sports depot to repeat down like how it is in the above image.Independent (detached) Table for 3-year rolling trend
I am trying to get a 3-year trend for a measure using an independent detached year dimension. The below is my logic: Fact - has a year column YearDimension - has a year column DetachedYearTable - has a year column DetachedYearTable Year is used in a single select slicer. 3-year trend measure is calculated as : Measure = SUM(Some Fact Table Column) RollingTrendMeasure = CALCULATE(Measure, Fact[Year] <= MAX(DetachedYearTable[Year] && Fact[Year] > MAX(DetachedYearTable[Year]-3) Now when I draw a bar graph with RollingTrendMeasure on y-a axis and YearDimension[Year] on another x-axis I see only 3 years based on slicer selection i.e selected year + past 2 years. But instead if I use Fact[Year], I get all the years from the fact. Since the YearDimension is connected to the Fact on the Year, shouldn't I be seeing only 3 years ? Why isn't the fact table filtered ? Also I just one value. So basically by graph is a straight line. I am trying to understand how this works, although I get the intended output by using YearDimension[Year]
Calling stored procedures to refresh the SSAS tabular model often results in errors
I have published 4-5 tabular models on the SSAS instance, and I refresh the data of the table model every day after the data warehouse is refreshed. However, they often report errors and the logs cannot identify any problems. Yesterday , last Sunday were successful, and today only one model is successful. What is the reason for this? The SSAS tabular model is a connected MySQL data source, and the error message is as follows: 001 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-001' returned the message 'OLE DB or ODBC error: [DataSource. Error] MySQL: Fatal error encoded during data read...'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 001 '. [SQLSTATE 42000] (Error 50000) This step failed. 003 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed. 003 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed. 004 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-004' returned the message 'OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 004 '. [SQLSTATE 42000] (Error 50000) This step failed. Normally, it takes about 30 minutes to finish job refresh. Looking forward to your reply, thank you.Use count with measure
Hi guys, I have a doubt about something that I believe is simple. I created a conditional measure in DAX to understand if the product passed the reorder point or not. # Status Stock = SWITCH( TRUE(), SUM(fStock[STOCK]) >= [Order Point], "Ok", SUM(fStock[STOCK]) >= [Order Point] * 0.8, "Attention", "Request Product") I would like to create a chart that contains the count of each of the 3 statuses. But when trying to use the Count function, it is not allowed to include measures, only columns.Paginated Report Visual No data in it
I have a paginated report over a Power BI Data set its just a table then I have added a Paginated Report Visual to the Power BI Report There are two Params ParamArea ParamMonth And these look ok However when I bring the table into the page with the two slicers on it, there is no data shows in the paginated Report. I know it woks because there is data when you test the paginated report against the same values in the two slicers. Im not sure what to do now to get this working? Any advice?
Summarize DAX help
Hello I have the following visual Measure=Pictures per camera / Accidents per segmet. How do i write the measure to summarize the data based on Segment. I am expecting the result as Segment Camera Pictures per Camera Accidents per segment Measure A1_14b 7631 4302 4 1075.50 A1_17 1019 6969 9 1163.11 1020 3499 A10/I_01 9024 14993 12 1249.42 Please help me how to write the measure to summarize based on Segment. Thanks in advance.
