Forum Discussion
Solved
Divide Measure not working as intended
Hello, I have this data model (see image below) that involves 3 tables ( one table related to location, two tables related to items) I have a few measures that uses the item-related tables. I n...
Solved this problem by removing [Delivery Pct of Deliveries] measure and instead focusing on using the [# of deliveries] measure as an alternative. By selecting show the value as 'Percent of grand total', I got the results I needed while display all the information correctly.
UPDATE:
The measure works when I reference the City column from the Location table instead of the Table2, replacing it with ALL(Location[City] ). However, I was originally using a bar visual to drill down to county level. I do have a separate County table that also has a relationship with Table2.
Is there a way to have this information displayed correctly when drilled up/down in one measure instead of two? Like using SELECTEDVALUE with Fields parameters?