Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I have a measure (not a calculated column because I saw it doesn't work to filter the calculated column based on another filed of a different table form the one in which I created that calculated column) and I can't give to a cell a certain value through this function:
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]);
CALCULATE(sum(values[value]);
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.
Can you please give an example, what you are looking for.
I just have to put into a matrix that has a named row which value is blank, a value calculated trough a measure. I have calculated the measure but I'm UNABLE to associate that measure to a specific blank row. I tried if(expression that idetifies the row; function that rapresents the value I want to give to that row), but didn't worked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |