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 everyone,
My marix table shows blank values when i used the below dax expression.
My table view currently looks like this :
Calculated Column used for "Average of Issue Score 2" this -
CALCULATE(AVERAGE('Distinct table'[Issue Score 2]), ALLEXCEPT('Distinct table', 'Distinct table'[Commodity], 'Distinct table'[Country], 'Distinct table'[% Weight], 'Distinct table'[Pillar]))
Note: Pillar is the 4 tpes of columns listed above (Cross-cutting, environmental, political, social)
Im trying to achieve a final product like this :
Calculated Column used in "Overall Risk by Country" for this -
CALCULATE(AVERAGE('Distinct table'[Issue Score 2]), ALLEXCEPT('Distinct table', 'Distinct table'[Commodity Type], 'Distinct table'[Commodity], 'Distinct table'[Country], 'Distinct table'[% Weight]))
Note: Pillar is the 4 tpes of columns listed above (Cross-cutting, environmental, political, social)
Can you help me out.
Thanks in advance! 🙂
Hi,@Diva20
Could you please show a more specific sample ?
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,
Caitlyn Yan
CALCULATE(AVERAGE('Distinct table'[Issue Score 2]), ALLEXCEPT('Distinct table', 'Distinct table'[Commodity], 'Distinct table'[Country], 'Distinct table'[% Weight], 'Distinct table'[Pillar]))
Current output that im getting:
But, what i want to showcase as an end result is the (below image) - DESIRED OUTPUT
NOTE:
First image - COLUMN "Average of Issue Score 2" and Second image - COLUMN "Overall Risk by Country". Both are same columns. (naming is different)
The above 2 columns - "Average of Issue Score 2" and "Overall Risk by Country", they are coming from a different table (a sub table from the main table populating the DISTINCT values).
Any help will be apreciated.
Thank you
D--
Hi,
Write your formula as a measure (not as a calculated column formula).
Hi,
I am not clear about your requirement. Share some data, describe the question and show the expected result.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |