Find first value above 50% by category using DAX
Dear DAX Brains Trust! I'm trying to write a column in DAX that returns the first value above 50% within a categorised cumulative column. For context I've got a big dataset off all the postcodes around Australia and with each postcode comes an income category, 14 to be precise, thanks to the Australia Bureau of Statistics (ABS). I've been through an arduous but insightful process via power query in which I have organised them by creating a list.generate function which has returned each income category within the postcode with cumulative running total of income % - Thanks to RickdeGroot (BI Gorrilla) and possibly the GOAT of M code. I've now got my data how I want it, and as a final step would like to create a measure or column. That returns the first value over 50% within the cumulative running for each postcode. I'm a bit stumped at how I achieve this, I've tried RANKX & TOPN but with very little success. Will post a screenshot of the data and attempted DAX code tomorrow. Any advice beforehand would be greatly appreciated.
Highest value of duplicate
Hi, i have 3 columns column 1 is unique, column 3 and 4 can have duplicates. Now i need to add a column to identify which has the highest value in column 1 when its a duplicate. Example: Index Id Name 1 A21 red 2 A21 red 3 A22 green 4 A23 yellow 5 A22 green 6 A24 blue 7 A21 red 8 A22 green 9 A24 blue I need to have the higehst value marked with yes in a caalculated column 4 Index Id Name Highest value 1 A21 red No 2 A21 red No 3 A22 green No 4 A23 yellow Yes 5 A22 green No 6 A24 blue No 7 A21 red Yes 8 A22 green Yes 9 A24 blue Yes Any idea to solve it? Any help is welcome 🙂 Regards
Issue with Value() function converting string to number
I am using a switch formula to simplify and bucket a column of mixed numeric and text values. The goal is to simplify values that are numeric with text to just the number. (For example, I have these values in the column: "2", "2g", "2 g" and I want all of them to be returned as "2".) There are some values in the column that do not have any numbers such as "dg" and "ph". I used the formula ISERROR(VALUE([mycolumn])) within my switch formula to return a value of "Other" for these values. The problem is with one single row that has the value "2a". This does NOT return as an error within the VALUE() function. It actually returns a value of 0.0833333 for a reason I can't figure out. Is "a" some stored variable? What is going on and how can I fix it??Compare values from 2 visualized tables in powerbi dashboard (NOT BACK END TABLES COMPARISON)
Hi there, I have a challenge for the expert powerbi community!! Within my company we are currently looking to compare two table values in the powerbi dashboard (FRONTEND) to return an marker wheter the individual green value (which is filtered by "studiegroep", "periode" & "voornaam") meets the groupbenchmark pink value (filtered by :"benchmarkyear" but with changing data based on a backend division of data). Using PowerQuery within the tables is not possible given the pink data is changing when using diffent filters (so the pink data is not directly from another back-end table but is only generated in the dashboard by using measures & filters in the dashboard. Normally in excell you would simply make a calculation based on the respective cells (see example below) and add a conditional formatting, see example in excell. However, I am looking for a similar solution within the powerbi dashboard. Is this possible in PowerBi? would love to hear from anyone who can offer help!  
Get latest value from other table that contains blank value
Hi, I need to return the latest value based on date of the entry. Table "Scoring Entry" consist of blank values and each test was submitted on different date and for different students. How am i supposed to get a table that looks like Table "Latest Scoring" that return only the latest scores for each students? I tried using FILTER, SUMMARIZE and LASTNONBLANKVALUE functions but that only return the result of MAX/MIN value of the scoring. Much Appreciated 🙂
Switch colour card filter by field value
I'm formating a card by FIELD VALUE Is there a way to get this switch formula to turn greater than 0 green e.g. "#094" and red if less than 0 e.g. "#d64550"; My current code is: Measure Value Color = SWITCH(TRUE(), [% Average 2019] >0,"#D64550", [%Average 2019] =0,"#252423", [% Average 2019] <0,"#094", [% Average 2020] >0,"#D64550", [% Average 2020] =0,"#252423", [% Average 2020] <0,"#094" ) It keeps turning red for some reason when it's +18.54% Thanks
