Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
72 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
31 | |
27 | |
24 | |
22 |