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]
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.
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.
How to remove a filter using DAX?
I have a column chart x is week and Y is a measure. I have a calculated column to filter and show the last completed week's data. Latest Week Check = IF(AND(REPORT[Fiscal Week]<REPORT[Current Week],REPORT[Fiscal Week]>=REPORT[One Week Ago]), "YES", "NO") Now, I need a tool tip that shows all the historical data removing the last completed week fiter. I tried writing a new dax for Y axis to remove the Latest Week Check filter added to the visual using, Rate All = CALCULATE(CALCULATE(REPORT[measure]), REMOVEFILTERS(REPORT[Latest Week Check])) But it does not seem to work I tried ALL and ALLEXCEPT, nothing seems to work. What should I do to remove the Latest Week Check for the tool tip?
