1

I'm trying to achieve the column "Sales = Chair" in power bi. The goal is to filter value for a specific category and populate the value in the rows of the same column.

Category Subcategory Sales Sales = Chair

Furniture Chair 100 100

Furniture Sofa 150 100

Appliances Washer 250 100

Appliances Microwave 200 100

user14955184
  • 15
  • 3
  • Can you please show your source and expected data separately? It's bit confusing now. – mkRabbani Jun 01 '22 at 03:16
  • Source:- Category Subcategory Sales Furniture Chair 100 Furniture Sofa 150 Appliances Washer 250 Appliances Microwave 200 Expected Date :- Category Subcategory "Sales = Chair" Furniture Chair 100 Furniture Sofa 100 Appliances Washer 100 Appliances Microwave 100 Stack doesn't let me post images – user14955184 Jun 01 '22 at 03:55
  • All I'm trying to do is select a specific measure value for sub category and populate the same value in rows in the same column – user14955184 Jun 01 '22 at 03:56

1 Answers1

0

Can you try a measure like-

new_column = 
CALCULATE(
    SUM(your_table_name[Sales]),
    FILTER(
        ALL(your_table_name),
        your_table_name[Category] = "Furnuture"
            && your_table_name[SubCategory] = "chair"
    )
)
mkRabbani
  • 16,295
  • 2
  • 15
  • 24