Column of related Table breaks measure
Hello, I have two Tables (A and B) and have a meassure (using only data from A) which works fine in my table visual, but when i add a column from Table B to the visual, the meassure breaks. SUMX(FILTER('A, 'A'[Flag]=1), 'A'[Value1] / 60 * 'A'[Value2]) I think the Problem is the many to many relatioship between A and B. For Key in A there are three rows in Table B matching B contains translations from differnt languages for that code. When i switch the added collumn from don't ssummarize to First or Last the problem resolves. Normaly a slicer on the page should filter unessecery translation in Tbale B, but they appear when i add the collumn to my table visual. Sorry for poor decription. But is there a way, maybe to Filter Table B in my measure with the selection made in my slicer, so i dont need to select first to get rid of unwanted translations?
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)?Divide with denominator as measure and numerator as related values from different table
Hi I am trying to define measure that gives "cost per kilometer" I have a fact table having [Equipment], [Loaded Distance] and [Deadhead Distance] column a dimention table called fixed Cost having [Equipment N] and [Fix Cost] columns I have a measure Equipment KMS = CALCULATE(SUM('Prototype Modeling_Freight'[Loaded Distance]) + SUM('Prototype Modeling_Freight'[Deadhead Distance])) Shown as a table visualization Through a relationship connection between Equipment and Equipment N MY REQUIREMENT : A measure defined for each equipment as [Fix cost] / [Equiment KMS] TIANeed help with distinctcount with filters from several tables!
Hi I have 3 tables with following data. Table 1 - Reseller Country - Hierarchykey - Reseller - End Customer Aus - 123 - Rondo - Endcust1 Aus - 453 - Rondo - Endcust2 NZ - 564 - Alfonso - Endcust3 Table 2 - Charge Material code - Currency - ChargeReseller - ChargeEnd Cust - HierarchyKey 1994424 - EUR - 10.10 -12.3 - 123 1005570 -EUR - 12.7 - 12.8 -636 1005570 -EUR - 20 - 22 - 956 Table 3 - Material Material code - Manufacturer Name - Description 1994424 - Soap - Slippery 4950603 - Leaf - Green 4958699 - Trunk - None Based on these 3 tables I need to calculate how many distinct Resellers have used only one Manufacturer - Soap. And how many have all the other Manufacturers except the Soap. The formula should be smth like this - Calculate Distinctcount of ResellerName, Filter where Manufacturer distinctcount is 1 AND it is Soap. The thing is - Each of resellers have many different Manufacturers they use so I think the main issue is to filter out the resellers that have only one specific. In Material table I already have the column that has "1" next to each Manufacturer when it is Soap, but can someone help me with correct formula to use? Or maybe help with creating join table?
