Sum a row using visible columns
I have created a table that allows a user to choose what data columns they wish to see (via field parameters). There are up to 4 possible values they can select from. I need to get a dynamic total across each row based on those selected columns. So, for example, if they choose all 4 severity levels, the first row would total 10, second row would be 3, etc. But if they chose only Sev2 and Sev4 (meaning only those 2 data columns would be visible), they would get 4 in the first, 2 in the second etc. There are other values that can be calculated as well (such as year over year percent of change and so on) but those would obviously be calculations similiar to this basic one. What formula would acheive that result?
Function to collect leftover hours if exceeding 8 hours of work?
I'm trying to configure a formula to calculate the 'Overage' Hours of a days work. From my data I did a 'GroupBy' within PowerQuery to condense all my columns to only the necessary fields to narrow down my calculation for easier functionality. However, I'm stuck on this final piece on this calculation. The goal is to be able to track how much time is worked past 8 hours (if you work 9 hours in 1 day, your overage hours would be 1 hour). In addition, a regular work week being 40 hours, I can exceed 40 hours and go into overtime within the same work day. I don't know how to manage this formula to sum 'Regular' hours and 'Overtime' hours together and subtract it from 8 to get the leftover hours worked. My current formula is super simple as I keep trying to build on it, but don't know how to go about it. =IF(SUM[Hours]-8<=0,"",SUM[Hours]-8) Date Category Person Hours 01/20/2025 Regular A 5.5 01/20/2025 Overtime A 3.5 01/20/2025 Regular B 5 01/20/2025 Regular B 4 Person A 1/20/2025 = 1 Overage hour (but 3.5 hours of Overtime) Person B 1/20/2025 = 1 Overage hour (No overtime accumulated yet) This is over thousands of rows of variances of hours worked. Apologies if it doesn't make much sense I can try to clarify more if asked. But I'm still fairly a novice at DAX and Power Query but would love some insight and advice on how to get this solved.
Measure to count columns that have the same strings of text in a different order
Hey Folks, I have a column of data that contains a topic or multiple topics that are seperated by ";" that may be in a different order. I'm trying to count the times particular combinations of topics are put together, i.e. As appears in regular table count Topic 1;Topic 2;Topic 3 - 1 Topic 3;Topic 1;Topic 2 - 1 Topic 4 - 1 Output I'm trying to get to: Topic 1;Topic 2;Topic 3 - 2 Topic 4 - 1 I have found the following solution on Stack Overflow that seems to be exactly what I'm talking about, however the context is for other databases than PowerBI / Power Query. r - Group strings that have the same words but in a different order - Stack Overflow I'm hoping that this is something that can be acheived via a measure rather than within power query. I already have a bridge table that lists all individual topics, so I'm wondering if its something I might be able to leverage as part of the meaure, but I'm very lost on this presently. Thank you for your help.
Sort the columns according to their name.
Hello dear! I need to order the columns of the chart according to the description of each one. For example: the first column "Excellent", the second column "Great", the third "Good" and the fourth column "Terrible". I couldn't figure out a way other than the constants in the axis sort options. Thank you very much in advance if anyone can help.
How to filter one plot by multiple exlusive filters?
I'm not sure if this topic should be here or in Desktop tab, so my apologies if i picked incorrect one. Hi there. I have a task which i'm unable to solve. I need to create a scatter plot showing temperature and population on axes by cities. And every city belongs to some region - nothing unusual. There should be a slicer for user to select region. But here comes the tricky part - i also need to add slicer where user can select city from another region - and this city should be displayed with all other cities. So, for example, when a user select Asia from region slicer there should be displayed all Asia cities, but if user wants to select city from city slicer this city should be also displayed with all Asia cities, even if it's not belong to Asia region. But when you pick Asia it applies filter to all cities, and you can't pick another one from different region. I tried to create two slicers which should filter another one, and data from it should bу displayed, but it doesn't work. Tried to tinker with filter parameters in visual by creating measures but also without success. Even not sure that measures can help because it should work with columns, and we can't change them dynamically. If you have any suggestions i'll be glad to hear.
Keep Columns Permanent in Matrix
Hello! I have a matrix with test and control columns where our test group is subdivided into test A and test B. The calculations are perfect and filters work just fine. However, I would want to keep the "Control" columns permanent even after appying filters to say Test A. In that way, I can compare numbers between Control and Test (A or B). Is this possible in Power BI? I am using the native matrix visual. Thanks!CALCULATED COLUMN WITH REPLACED BLANKS
Hello friends, I'm having a trouble with building a DAX Measure to get some values and displays them as row values on matrix. Unfortunately when i use calculate doesn't work, my matrix turns into a huge amount of rows that i dont want. There's any way to only replace blanks without making the matrix "bigger". The quantity column below shows the quantity of a material, the blank values are materials that currently we dont have in storage, we have two tables, one with a list of all material numbers and another with all materials in storage, the first column of this matrix is the material number. Can you guys help me? Thanks so much.
Nueva columna copiar datos
Hola a todos. Estoy trabajando con una consulta llamada "Conformacion ICO", en la cual busco crear una nueva columna que me tome el elemento resaltado en la columa "ICO" y me lo replique para todos los valores resaltados de la columna "Documento", he intentado con varios codigos pero no he obtenido el resultado esperado. La columna salida "ID ICO" deberia verse de la siguiente manera. Agradezco de cualquier ayuda para poder solventar este problema...Gracias!!
