Get the value for sub category by certain %
Hi all, I would like to get the total sales of subcategory where the main category is more than certain % I would like to show all the sales of sub category where the total weightage is more or equal to 30%. for example, the main category that is more than 30% are "Clothes 2" and "Car" and now, I want to get all details of item in sub category which are under "Clothes 2" and "Car". How can I solve this by creating the measure in power bi ? Thanks in advance.
create measures with filters
Hello, I need to create measures using some filter to be able to make some card visuals. here is what I did: I have my date base with all years information, so for making the "sales per year" i made to measures: 2025 = SUM(...) and filtered in 2025 poryjected sales. 2024 = CALCULATE([Facturación],SAMEPERIODLASTYEAR('Calendar'[Date])) - I created a measure of get the sales of previous year. than I made a measure to get the difference between both 2024 adn 2025 sales. WHAT I SHOULD DO: I made to charts one "increasing of sales" detailed all the "clientes" that has a positive result and I was using the filter panel. and another of "lost sales" with all the negative results. I need to add some cards to summarize the totals. I have one showing the total of sales in 2025 I need a card showing the total of increaisng sales that is "2,066,314" and a card showing the total of lost sales that is "-919,865" thank you!
Why is my measure not evaluating to 1?
Hello Forum, I have a series of Measures I am trying to use to identify the first instance of a Customer placing an Order. I need to accomplish three things: Identify the Minimum Order Date across a series of dimensions Return "1" for rows where the order falls within the date context Sum all rows where "1" was returned I am able to accomplish one and two, but my third Measure is giving unexpected results. Why are the highlighted values appearing as blank? __NewAccounts_A_FirstOrderDate: __NewAccounts_A_FirstOrderDate = var maxContextDate = MAX( Dates[Date] ) RETURN CALCULATE( MIN( Sales[Delivery Date] ), ALLEXCEPT( 'Sales' , Customer[Customer No.], --Customer[Customer], Supplier[Supplier], Location[Branch] ), Sales[DeliveryDate] >= DATE( YEAR( maxContextDate ) - 1, 1, 1), Sales[Delivery Quantity] > 0 ) __NewAccounts_B_FirstOrderInContext: __NewAccounts_B_FirstOrderInContext = var maxContextDate = MAX( Dates[Date] ) return IF( [__NewAccounts_A_FirstOrderDate] >= DATE( YEAR( maxContextDate ), 1, 1) && [__NewAccounts_A_FirstOrderDate] <= maxContextDate, 1, 0 ) __NewAccounts_C_DistinctNewCustomers: __NewAccounts_C_DistinctNewCustomers = CALCULATE( DISTINCTCOUNT( Customer[Customer No.] ), FILTER( Sales, [__NewAccounts_B_FirstOrderInContext] = 1 ) )
