Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Hi @music43
in the filter pane select the measure and choose "Not Is blank" and applythe filter.
Hi @music43
in the filter pane select the measure and choose "Not Is blank" and applythe filter.
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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |