User Profile
Alexx22
Regular Visitor
Joined 7 months ago
User Widgets
Contributions
Re: Temporary table with filters, measure in matrix
Thanks to the answer. But the 2 problems are technicals doesn't matter at all the model. I can not resolve this without measures, because in the report lvl we have 4 filters that we need to filter the data. So, the question is whether there's a more "optimal" way to do something like this, and since I don't know, it seems to me that PowerBuilder has a limitation that could be corrected. Virtual tables are necessary because we can't perform calculations at the model level due to the filters. Can be possible calculate this in model lvl with filters? I think not, how can I do this more accurate? Thanks!694Views0likes1CommentTemporary table with filters, measure in matrix
Hello everyone. I need know if this is capable or not in power Bi. Have this situation and i need a solution. I came up with "this" and it works, but it's "slow". I have a table with thousands of records. It has four key fields that filter it. With these filters applied at the report level, the table is reduced to approximately 160 records. What I need to do with these records is calculate a "time" using a DAX measure. This is repeated approximately 15 times, with the time changing for each of the "15 columns" one of those 15 is special, and then sort an entire array based on that time (It can be anyone, let's say number 8). I have a 160 x 15 column matrix. If I'm looking for the measure for the "8" and want to sort it based on that time, I need to add a measure that calculates only the 8, and the first problem is that this is repeated 15 times with the same data. The first question is, shouldn't Power BI allow "unique" columns in a matrix? In this case, it only allows me to see this measure once. I solved this as follows: I only want to show the result in column 1, leaving the remaining 14 columns blank. I want the measurement name to be a space so it's not displayed in the matrix. And I want "hour" to be displayed with a blank background and text, so it appears as a blank space. (Displaying the data this way isn't what I need.) Based on this, I need to do the following, which is a bit more interesting. When I have the time from column 8, I need to calculate how many minutes there is a difference between the time of one record and the previous one. (For this, it must be sorted based on that time.) Here's the other question: How do I solve this? Based on a measurement, calculate the difference with your previous result. I solved it in the following way: A DAX measure that I would have to perform for each record, recalculating the entire time and finding the highest time that is lower than the current one. This works BUT it's slow and rightly so. If I have 160 records for each one, I have to calculate 160 more records, where I have to remove the filters and then reapply them because the row context would only filter one record out of the 160. Shouldn't Power BI allow the creation of temporary tables where filters can be applied at the report level, and the table remains cached in memory? This will allow the entire table to be calculated only once, and not 160*160 times in one measurement. Thanks everyone.Solved806Views1like6CommentsOrden de columnas en matriz
Buenas tardes, Tengo una consulta que no logro resolver y queria ver si alguien conoce una forma de hacerlo. El problema principal es que necesito dar un orden a las columnas de una matriz, hasta donde tengo entendido el unico modo es mediante una columna calculada. El problema es que mientras lo hardcodee funciono, pero la realidad es que necesito 2 valores en base a los cuales se filtra la la tabla que vienen dados por un filtro a nivel de reporte. Y como tengo entendido que una columna calculada no es filtrada por un filtro de reporte me parece que es imposible. Hay alguna forma de ordenar la matriz de forma horizontal ( por columnas ) que venga dado por una medida? De forma vertical se que se puede, pero horizontal no pude encontra forma. Saludos!Solved651Views0likes4CommentsRe: Copilot, limitations?
Thanks everyone for the response. I'll reply you because i understand all that points BUT... I don't think the same. My prompt is very complete with the info that i need and the AI needs. The measures are very clear and i ask for specific answer. I have the measure with the real name, wrike what i need very clarity and copilot can not resolve it. ChatGPT resolve it easy, is no hard guys.. I understand the limitations but this is very useless for me. "Intelligent" is nothing for to much AIs not alone for copilot, but this is embarrasing i ask for a aritmetic result is easy for a simple calculator.. When i ask for cross report means some like this: If one said "passengers" 100.000 in nov. And the other said "passengers" 80.000 "NS" and 20.000 "SN" in nov. ¿How many passengers of the 100.000 are NS and how SN? A easy summary for 2 reports...7KViews1like3CommentsCopilot, limitations?
Hi everyone, I have some questions for this Copilot AI. In my company we are testing this AI for our reports and I ask some questions in my opinion easy ones... And copilot can not resolve it.. Soo.. Is Copilot a bad AI? Even i asked in others AI likes chatg.. some more difficult issues and solve it, but Copilot can not do... a simple operation? For an easy example, I have a report for passengers and I have the TOTAL in months, I ask for Copilot if he can tell me whats is the % of evolution between months and answer "I can't do that, I need the measure in the report". There is some limitations for that or what's happening? This AI is not connected with models and data? Even in the same area we have 2 reports that we have some relational data and we can not ask some question between them.Solved7.2KViews3likes10Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.