Forum Discussion
Measure
Hi Anonymous ,
I'm a little confused by your description. Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hmm... For example:
If I have the dax measure:
if(rows[cell]="x";1;2) i can see 1 as value of my matrix on row where row[parent]="m"
while if I have:
if(rows[cell]="x";CALCULATE(sum(values[value]);
filter(rows;rows[parent]="fff");FILTER(rows;rows[child]="rrr");FILTER(columns;columns[parent]="aaaa"))) I see nothing on row[parent]="m"even ifCALCULATE(sum(values[value]);
filter(rows;rows[parent]="fff");FILTER(rows;rows[child]="rrr");FILTER(columns;columns[parent]="aaaa")) is giving me the correct number if I put it on a matrix without any rows or columns.Hi Anonymous ,
For the formula:
CALCULATE(sum(values[value]);
filter(rows;rows[parent]="fff");FILTER(rows;rows[child]="rrr");
FILTER(columns;columns[parent]="aaaa")),
you applied the condition rows[parent]="fff", so it will return the aggregate value based on rows[parent]="fff", when rows[parent]="m" is placed in the filter context, the measure cannot return an aggregate value based on rows[parent]="fff" and will return nothing, I think this may be the problem.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.It doesn't work even if I put the filter only on columns.
I think this is because I then try to filter by another column contained in Values, the year, and I noticed that the calculatedcolumn is shown as a total and not associated to any year of Values table.