Complex conditional summing
Hey everyone! how you doing? I have been now a month trying to make this logic work in dax but no solution. Cna anyone please help me with this? or even just say that power Bi will not be able of doing it happen? Here is the thing: I need to distribute evenly the stock of an item throught the orders of this item, in a way that the result is as shown in the table bellow: I need the stock to be distributed in a way that when its not enought to the order it will try to fit in the other order until the total stock is used. Use the stock amount of 21 for this example, you will see that the ones set as available, when summed will be exactly 21. The status column is the outcome that i need from the dax code. This is very hard, i don't even know if its possible; can anyone please helpe me with it? Thankyou a lot allready.
Total row not showing the correct amount
Hello i have this issue, i have a Measure called $ / Ton $ / Ton = SUM(BD[MXN]) / SUM(BD[Movidas]) Also this measure called Impacto: Impacto = SUMX( VALUES('BD'[Ruta]), VAR VolumenAuto = CALCULATE(SUM('BD'[Movidas]), 'BD'[Transporte] = "Auto") VAR VolumenFFCC = CALCULATE(SUM('BD'[Movidas]), 'BD'[Transporte] = "FFCC") VAR CostoPorTonAuto = CALCULATE([$ / Ton], 'BD'[Transporte] = "Auto") VAR CostoPorTonFFCC = CALCULATE([$ / Ton], 'BD'[Transporte] = "FFCC") RETURN IF(VolumenAuto > 0 && VolumenFFCC > 0, ROUND((CostoPorTonAuto - CostoPorTonFFCC) * VolumenAuto, 0), 0 ) ) In the Rows the value of Imacto is correct and if i compare it with the excel data is all good but the problem is in the total is not showing the correct amount In PBI in Excel; what am i doing wrong in the Impacto Measure? thanks in advance.
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?Count on a measure
HI All, I have a running Measure in my pbi where i the out put is put into four seperate catagories. What i would like to have is a count of how many there are of each of the catagories, but i cant seem to get a sum or count fucntion that works. CALCULATE( SWITCH( TRUE(), [Avg. Days Untill Contract Expires] > 1095, "> 3 years", AND([Avg. Days Untill Contract Expires] <= 1095, [Avg. Days Untill Contract Expires] > 730), "2-3 years", AND([Avg. Days Untill Contract Expires] <= 730, [Avg. Days Untill Contract Expires] > 365), "1-2 years", AND([Avg. Days Untill Contract Expires] <= 365, [Avg. Days Untill Contract Expires] > 180), "< 1 year", AND([Avg. Days Untill Contract Expires] <= 180, [Avg. Days Untill Contract Expires] > 0), "< 6 month", ISBLANK([Avg. Days Untill Contract Expires]) , "None"), ALL('Date') ) Thanks in advance
