Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

not equal operator not filtering

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" )
)
)

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Also is your number formatted as Text or Whole Number, Decimal Number or Fixed Decimal Number? As that could then also affect the <>





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

6 REPLIES 6
GilbertQ
Super User
Super User

Also is your number formatted as Text or Whole Number, Decimal Number or Fixed Decimal Number? As that could then also affect the <>





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

Hi there

Do you have a working example we could have?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thanks for your help @GilbertQ it worked when I changed data type of parent id,  FROM TEXT TO WHOLENUMBER

 

Thanks

Mazhar

Great that you got it working




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi there, do you have some sample data, as well as what the current output is and the desired output?

It would appear that you might be able to create this filter in the Query Editor which will then make it a lot easier to create your measure without having so many conditions.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.