Forum Discussion
row content
Hi All, I have a final table which category,type and executive summary. Category - ( Each Category has type 1 and type 2 each category and type has repeated executive summary as per the below table...
anmolmalviya05
Super User
Super UserHi Vanu , Please try to update your dax measure as below:
type =
VAR Model_Value =
CALCULATE(
SUM('Dax'[Previous Qtr]),
Final[Category] = "Chair",
Final[Type] = "Type 1",
Final[Exec Summary] = "Model"
)
VAR Brand_Value =
CALCULATE(
SUM('Dax'[Previous Qtr]),
Final[Category] = "Chair",
Final[Type] = "Type 1",
Final[Exec Summary] = "Brand"
)
RETURN
IF(
Brand_Value = 0,
BLANK(), -- Handle division by zero
DIVIDE(Model_Value, Brand_Value)
)