Process data table to obtain subtotal table
Hello, I have a Database-like table which resumes Work Orders (WO) and Tasks for those WO where there's as many lines as there's Tasks. For example, I have 5 tasks for the same WO where each has their own planned work hours, actual work hours, planned costs, actual costs, etc : I would like to have a second table, from that table, to show WOs with the subtotals only, and keep WO-related data only : Is it something that can be done? Thanks! PS. I know Matrix can do that, but I don't want show the data necessarily with a table.
Filter two tables on Multiple Criteria
Hello! this might be confusing and I can't share any data so I will do my best! I have two tables: SynthesizedItems and Failures. I have a report page dedicated to fail rate. This is just the number of fails/number of synthesized items. (measures in the failure table) Originally, I linked the two tables to a common date table. this allowed me to see the fail rate adjusted based on the users filtering by date. Then, I realized I needed to be able to break this down further. I added an additional table called DepartmentFilter and linked it to department in both the fail and synthesis tables. this seems to work. Now my question. My report has SEVERAL factors involved that users can slice their data by (all coming from the failure table) and I noticed that if the user filters to a certain customer, the fail table will filter but not the synthesized items table. (makes sense because they are not related, although customer exists as a field in both tables). Is it possible to make this method work where any filter the user applies will affect BOTH tables and therefore give an accurate rate? Is there a limit to how many common "filter" tables I can create and link to both? Is there a way to do it other than creating tables for each field? really trying to avoid this since it would be about 10 fields.
Create Dynamic Measure Tables using Values from Slicer
I have a Dynamic Measure Table and need to pass in the slicer value. Unfortunately the value of the slicer is not being passed into it. I tried creating a measure to select value from the slicer and input into the dynamic table and still no luck. The output of the Dynamic table is displayed via a Table Visualization. I tested the Year and Month Measures in cards and they are fine. Has anyone come across this issue before? Selected Year = SELECTEDVALUE('Date'[Year]) Selected Month = SELECTEDVALUE('Date'[Monthnumber]) TestMetricsTable = VAR selectedyear = [Selected Year] VAR selectedmonth = [Selected Month] VAR DataTempTable = DATATABLE ( "Category", STRING, "Year", INTEGER, { { "none", 0 } } ) // RETURN SELECTCOLUMNS ( DataTempTable, "Category", "Selected Date", "Year", selectedyear, "Month", selectedmonth )Proper Calculation of Facts/Values from Dimensional Table
Source ( Download Here ) Userstory: Imagine you have big star shema model and important values/facts in dimensional Tables. And you don't want to mess up your fact table with multiple low cardinality columns. Question: How to proper handle these dimTable facts/values? Simplified Example: Question: How to get DESIRED YearVolume (because by default it gives 2200 (Totals) in each cell)?Create Table only with records that met the conditions
Hi everyone, I have a request that gives me a hard time. I have to create a table with data from 2 tables bringing only the records from Table A that by their sum Amount group are equal or less with the corespondent Amount from Table B. The relationship is Table A (Many) - (One) Table B by the Customer ID. Here are the 2 tables: The expected result table: Thank you in advance, Kta
