Hide rows if another DAX measure returns blank

music43 — Mon, 06 Jun 2022 23:11:16 GMT

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

Re: Hide rows if another DAX measure returns blank

tamerj1 — Tue, 07 Jun 2022 03:00:40 GMT

Hi music43

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

Re: Hide rows if another DAX measure returns blank

music43 — Tue, 07 Jun 2022 07:40:36 GMT

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.

topic Hide rows if another DAX measure returns blank in DAX Commands and Tips

Hide rows if another DAX measure returns blank

Re: Hide rows if another DAX measure returns blank

Re: Hide rows if another DAX measure returns blank