When you go to page 1 of the report view you will find two slicers, an image and three tables.
The main table I am concerned about is the one in the middle.
I want to add a measure that will multiply the number of objects (5 when starting out not operating the slicers) with 4.
When you start out the table in the middle shows 3 rows as I expect from the Maintenance table.
But when I add my measure that multiplies the number of objects it will show the correct value of 20 but it will add a significant numbers of unwanted rows to the table (to 15 rows).
My Measure looks like this: Meting = COUNT(Equipment[ID])*4
Before adding the measure: Meting to the table in the middle it looks like this:
After adding the measure: Meting to the table in the middle it looks like this:
You can see that the resulting rows in the table expand from 3 results to 15 rows!
I expect the measure to only be applied to the initial 3 rows.
I have tried it with creating a column instead of a measure but then it won't change according to adjusting the slicers. I have googled and tried to change to DAX definition with for instance CALCULATE and FILTER but no luck so far.
So I expect the DAX definition of my measure: Meting is not correct in this case.
But I am not that experienced yet.
Some help would be very much appreciated!
Why do the number of resulting rows change from 3 to 15 when adding the measure?
What do I need to do to add a similar column that will be able to respond and calculate accordingly to adjusting the slicers?
Situation 1 with slicer car active. Without the measure it shows the 2 resulting rows that I expect. But with the measure active on the table it will show the 15 rows again. Which is what I didn't expect and what I am trying to avoid. Can I add a calculation like this visible in the table to only the 2 resulting rows when applying the object slicer to car?