Forum Discussion
mp390988
Post Partisan
Post Partisancalculate with summarize vs values
Hi, I have created the below measure which is just a very expanded way of achviening the same result by using keepfilters but i am doing this for my own understading. Contoso and Red only v3...
Hi,
Yes I have had to opportunity to look at the information provided by Deku and Ashish_Mathur .
I find Deku suggestion helpful and I have taken on their suggestion and responded back on this thread, now I am awaiting for a repsonse to help me further.Thank You
mp390988Post Partisan
Post PartisanThank you for pointing me to the TREATAS function.
Given that the following is my model:
I implemented my measure as follows using the TREATAS function to create a virtual relationship between the two tables Summarise_Example and Product.
Contoso and Red only v4 = CALCULATE(
Sales[Sales Amount],
Filter(
TREATAS(
SELECTCOLUMNS(
Summarise_Example,
"Brand", 'Summarise_Example'[Brand],
"Color", 'Summarise_Example'[Color]
),
'Product'[Brand],
'Product'[Color]
),
'Product'[Brand] = "Contoso" &&
'Product'[Color] = "Red"
)
)But I am still seeing repeated values printed against brand and color that does not equal "Contoso" and "Red" as per the below diagram when I drag the above measure into the visual.
why is this?
