Simple measure to give back a single value ..
Dear community, Obviously, I am still struggling to manage even simple measures. I need a measure to give me back for row ORDER in the Budget[Category-Id] the related VALUE also in the Budget[Category-Id] (in this case 120.000). I am not sure if I need FIND, LOOKUP or any other function. Many thanks for your help. olumn
Value from measure not filtering other visuals correctly
This has been puzzling me for a very long time! I will try my best to explain: I have a fact table and a dimenstion table (plus many other tables that aren't included in these calcs) I have created 2 measures Measure 1 counts all the rows in the fact table it is used to count number of rows per group (group is from a dimension table) Measure 2 counts all the rows in the fact table (using measure 1) but has a filter on one of the columns it is used to count number of rows per group (group is from a dimension table) that match the criteria "Yes" It all looks good, but when I click on the '1' in the second visual, it does not filter the first visual correctly, and I can't figure out why the measure is completely ignoring the "Yes" filter There is a relationship between both tables (one to many) and I have tried changing this to both directions as well. The only way I can get this to work is by adding the criteria column from the fact table, as a filter on the visual, and selecting "Yes" Then when I click on the '1' it filters the top visual correctly I can't use this method because I have another column (with a "Yes" "No" criteria) that I need to show in the same visual, and having a visual filter on one column affects the values on the whole visual. Behind the scenes, it seems to be reading the data like this (where it gets the 128 number from) Any help would be extremely appreciatedMeasure for conditional formatting
I have a matrix table with the following: Product in rows, Region in columns, Values are the total amount of items we have on stock, and the tooltip shows the location of the product, the specific lot and the lot's expiration date. All records come from table "Inv Producto" I want the matrix to have conditional format to indicate what product of what region has expiration dates in X days (using a What If parameter, I think that's where the issue resides in) so technically the '3597' should be highligted in Red just like the other cells of the table, and when you hover over the value, you can identify which lot is the one about to expire...but it is not being highlighted and those items could be lost in the analysis. Measure for conditional formatting is: Below Threshold color = IF ( AVERAGEA('Inv Producto'[DaysToExpiry]) <= DiasAntesDeExpirar[DaysToExpire Value], "Coral" ) Column DaysToExpiry is: DaysToExpiry=Duration.Days(Date.From([ExpDate])-Date.From(DateTime.LocalNow())). ExpDate is in mm/dd/yy format What If Parameter to define expiration in the next X days: DiasAntesDeExpirar = GENERATESERIES(0, 365, 1) I think the issue is that CDMX is the one that has most products, so the average I am calculating is very high, thus it doesn't meet the criteria for the formatting but I have no idea how to do the calculation to identify each lot's expiration date and format based on that value only. Any help is appreciated!Fill Blanks with latest if based on sequence
Hello there, I'm having some trouble on solving this one. To give a breif example, we have a sequence from 1 - 5 each with a status and date. Sometimes the user skips this sequence and now I'd like to fill the gap with the latest date available. Example ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 Jan 5 2021 025755 Hot Lead 3 To be filled 025755 Signature Pending 4 To be filled 025755 Success 5 Jan 25 2021 Example2 ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 To be filled 025755 Hot Lead 3 14 Jan 2021 025755 Signature Pending 4 025755 Success 5 Now as you can see we have 2 statuses in example 1 that were skipped and thus have no dates. My objective is to fill these blank spaces for each group(ID) with the latest date available based on the max status/statusID. In example 2, 1 status was skipped and the latest current Id is 3, so we only need to fill the one in between. By default, status(ID) 1 always has a date. Thanks!
Sum measure is cannot be filtered by year
Hi, I am trying to compare a companies' operating cashflow (10 years of data) with it's capital expediture (5 years of data). I created a sum measure for each of them. However, when I put them graph, either of the measure is not filtered by the year (depend of the number of years I display) and instead, reflected the grand total across the year. May I know what did I do wrong? Thank you.
Measures keep returning (Blank).
New to Power BI so please bear with me. I have 3 tables. Date: All of 2017 dates + countries. Rev: Has the number of orders and USD Revenue by date/country Traffic: HAs number of website sessions by date/country The dashboard slider is the dates from Date sheet. I have created relationship between the tables by creating a column, Date&Country. While trying to setup a card for USD Revenue, I keep getting (Blank). I have checekd the data type under modelling and it shows decimals. Also, for transactions, I have created a measure to count the number of transactions, based on the slicer setting. Transactions = counta(Revenue[Order #]) . Again, this returns a (Blank) when I use a card. Any idea why I keep getting (Blank)? Thanks.
