Measure the relevance of i item
Hello there again, I need to find out how to calculate the relevance of an item compared to the general value. i have here the dashboard for you to download (ControleDaProducaoMaisLeve&BALSend.pbix) and see. What i need is the item in the visual table to be tested to see its relevance compared to the others, the logic is: if i remove this item, or not consider it, or filter all but leave it out, will the amount of "CountAvailable01" still be the same or it will decrease compared to the value on the card "Ped. Com Potencial"? if it decrease, the item is somehow relevant, if it does not do any difference its no important, a whay to measure the amout is the formula (1-"Ped. Com Potencial"/"CountAvailable01"); with that i will have a percentage of how important that item is to the general situation.. It might feel a little confuse, hope you guys can help me, i've allready tried a lot and used all AI i could to help me. Thankyou a lot
DAX Measure that accounts for previous dates data and not future dates data based on current date
Hello everyone, I am working on a financial report that is connected to an excel document full of referenced data. In Power BI desktop, I am hoping to display the average COGS per day (Cost of Goods Sold) in the form of a PBIX card on a Year to Date scale. Chronologically speaking, the data is organized by week (Mon-Sun). I have references set up in excel to capture future data as it occurs for this year. Below is an example mockup to better visualize my data/request: The issue I am having here is that the average COGS/day is taking into account future weeks where the data is evidently zero. For instance, today's date is 7/21, so all future weeks (weeks of 7/25, 8/1, etc.) are being included in this average and are therefore skewing this metric. I am hoping to write a measure that only accounts for weeks prior to the current date. Any help/tips on my ask would be very appreciated! Thank you in advance.
