cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jct999
Helper III
Helper III

Measure that depends of the context + always exclude one value

Hello,

I have a fact table with a few columns. Among them :

  • A column contains Categories : A, B, C or null
  • A column contains Quantity, that are integer.

I want to create a measure that calculates the sum of the Quantity, with the following rules : 

  • If there is no filter/slicer context for the Category column in the report, add the quantity for all non-null categories.
  • If there is a filter/slicer context for the Category column in the report, add the quantity for the selected categories except null

In other word, the measure add quantity depending of the filter context, but null-category is always excluded.

What is the best way to do that in DAX ?



Thanks

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.