Forum Discussion
Measure that keeps one filter while removing another filter both on the same table
Hi I need some help with a DAX measure that removes one filter while keeping another filter both on the same table. The datamodel is about 6 companies each having multiple locations in different...
wdx223_Daniel
Community Champion
Community Championtry this
Market_share =
VAR Grand_total_capacity_selectedarea =
CACULATE (
SUM('Locations'[Capacity]),
ALLEXCEPT('Locations',‘Municipalities'[Name]),
'Locations'[Location_type] = "A"
)
VAR Company_capacity = [Sum_of_Capacity]
RETURN DIVIDE (Company_capacity, Grand_total_capacity_selectedarea, "")