Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
19 | |
18 | |
18 | |
15 |
User | Count |
---|---|
39 | |
22 | |
18 | |
15 | |
12 |