Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calculate a measure using below formula , But its not filtering properly
NOT EQUAL OPERATOR<> Not giving desired output
Please advice thanks
Franchise = CALCULATE(
SUM('Model'[Sales]),
FILTER(
'Model',
('Model'[Store] = "1" && 'Model'[AccountID] <> "11435") ||
('Model'[Store] = "2" && 'Model'[AccountID] <> "15663") ||
('Model'[Store] = "3" && 'Model'[AccountID] <> "9863") ||
('Model'[Store] = "4" && 'Model'[AccountID] <> "9483") ||
('Model'[Store] = "5" && 'Model'[AccountID] <> "11435" )||
('Model'[Store] = "1" && 'Model'[AccountID] <> "8351") ||
('Model'[Store] = "3" && 'Model'[AccountID] <> "9288") ||
('Model'[Store] = "4" && 'Model'[AccountID] <> "9288") ||
('Model'[Store] = "5" && 'Model'[AccountID] <> "8351") ||
('Model'[Store] = "1" && 'Model'[AccountID] <> "4378") ||
('Model'[Store] = "2" && 'Model'[AccountID] <> "4378") ||
('Model'[Store] = "3" && 'Model'[AccountID] <> "8411") ||
('Model'[Store] = "4" && 'Model'[AccountID] <> "8411") ||
('Model'[Store] = "5" && 'Model'[AccountID] <> "4378") ||
('Model'[Store] = "6" && 'Model'[AccountID] <> "4378" )
)
)
Solved! Go to Solution.
Please help which opertor to be used if arguement to be filtered is set as "Text". Operator "< >" is not working for filtering @ "Not Equal to".
Thansk in advance
Thanks for your help @GilbertQ it worked when I changed data type of parent id, FROM TEXT TO WHOLENUMBER
Thanks
Mazhar
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |