Hide rows if another DAX measure returns blank

[music43]

Hi

I have two fact tables (Sales transactions and Product Prices*) which share relationships with multiple dimension tables:

DimProduct (1) to (m) fctSales

DimProduct (1) to (m) fctPricing

DimCustomer (1) to (m) fctSales

DimCustomer (1) to (m) fctPricing

I have 2 DAX measures. 1 calculates the margin based on selling price against cost based on a What-If parameter (only showing results that are less than or equal to the What-If parameter value). The 2nd DAX measure calculates the value sales.

I have created a simple matrix with customer and product on the rows and added both measures.

The margin measure correctly hides values that exceed the What-If parameter but when I add the other sales value measure I get more rows and the 1st measure shows blanks.

How can I hide values/blank values in the 2nd measure when the 1st measure returns a blank?

*over complicated pricing - each product can have 1 to 4 different prices/qty breaks per customer

Thanks

[tamerj1 · Accepted solution]

Hi @music43 

in the filter pane select the measure and choose "Not Is blank" and applythe filter.  

[music43]

Thanks @tamerj1 

That appears to have done what I need. I think I was so focused on a DAX solution, I forgot about the filter options!

Thanks again.