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.
Hello
I can't understand why this filter returns information about agency of "Paris" and "Aix" when I'm only asking for "Niort".
Can somebody explain where I'm wrong?
Solved! Go to Solution.
Hi,
So it seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I just tried it gives this formula =>
Hi PatrickByGecko,
You need to use measure instead of calculated column(which will apply result to all table), you could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm sorry but it is a measure (have a look underneath) .
Could you give an example of syntax?
You're almost there.
Here is the example code,
Average Test = CALCULATE(AVERAGE(Orders[Quantity]), FILTER(Orders,Orders[Ship Mode] = "First Class") )
Well done Siva. That works.
But my results need more tuning because I need to calculate average for distinct values of an other columns. For instance in your example Destination;
Quantity Ship Mode Destination Year
8 First Class France 2019
3 First Class Usa 2019
10 First Class France 2020
The Average we saw before will give (10+3+8)/3 =7
The Average for distinct Destination will give ( (18/2=9) + 10 ) /2 = 8
How can I do that?
🙂
Sorry I did a mistake on what I mean =>
----------------------------
Quantity Ship Mode Destination Year
8 First Class France 2019
3 First Class Usa 2019
10 First Class France 2020
The Average we saw before will give (10+3+8)/3 =7
The Average for distinct Destination will give ( 18 + 3 ) /2 = 10,5
How can I do that?
----------
Thanks
But it don't works with a filter =>
Have you tried this?
Calculate(<exp>,
Hello
I succeeded this way =>
Hi,
So it seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |