Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 3 tables: Colour, Category, FactSales:
I have to create measure, to Sum amount of "Red" sales. Every row should display this value.
I tried to do it:
I expect to get 20 in each row. How can I create measure correctly and combine two ALL() functions for two tables?
Solved! Go to Solution.
@Anonymous -
Does this accomplish your request?
MeasureRed = CALCULATE ( [Measure], ALL ( FactSales ), Colour[Colour] = "Red" )
Proud to be a Super User!
What's happening is that, looking at the first line in your "both fields" example,
Cross is filtering out 4 rows from factsales
then red filters, from within those rows, one row of red...whose amount is 6, which is what you see in your table.
So as well as getting All() from the color table, you need to get ALL() from the fact table
something like
MeasureRed = CALCULATE( [Measure];ALL(FactSales); FILTER(ALL(Colour); Colour[Colour] = "Red" ) )
Help when you know. Ask when you don't!
What's happening is that, looking at the first line in your "both fields" example,
Cross is filtering out 4 rows from factsales
then red filters, from within those rows, one row of red...whose amount is 6, which is what you see in your table.
So as well as getting All() from the color table, you need to get ALL() from the fact table
something like
MeasureRed = CALCULATE( [Measure];ALL(FactSales); FILTER(ALL(Colour); Colour[Colour] = "Red" ) )
Help when you know. Ask when you don't!
@kentyler wrote:MeasureRed = CALCULATE( [Measure];ALL(FactSales); FILTER(ALL(Colour); Colour[Colour] = "Red" ) )
Thank you. This is exact what I want.
@Anonymous -
Does this accomplish your request?
MeasureRed = CALCULATE ( [Measure], ALL ( FactSales ), Colour[Colour] = "Red" )
Proud to be a Super User!
@ChrisMendoza wrote:@Anonymous -
Does this accomplish your request?
MeasureRed = CALCULATE ( [Measure], ALL ( FactSales ), Colour[Colour] = "Red" )
Yes. It works perfect. Thank you!
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |