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...
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) )
I could not use sum since value was created in measure.
i repharse the dax but it is not working