Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Greetings Power BI community!
I need to replicate the Excel matrix shown in the snippet below, in Power BI matrix. I've tried using a combination of formulas in Power BI, but the output isn't the same as in Excel. Could any expert please help me with this? I'm new to Power BI and eager to learn. Thanks in advance!
Solved! Go to Solution.
Hi @kjsddf11 ,
Thanks for @ryan_mayu reply, here's how it worked for me
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a column
Column =
var _equal =
CALCULATE(
MAX('Table'[Value]),
FILTER(
ALLEXCEPT('Table','Table'[Name]),
'Table'[Name] = 'Table'[Name2]
)
)
RETURN
[Value]/_equal
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @kjsddf11 ,
Thanks for @ryan_mayu reply, here's how it worked for me
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a column
Column =
var _equal =
CALCULATE(
MAX('Table'[Value]),
FILTER(
ALLEXCEPT('Table','Table'[Name]),
'Table'[Name] = 'Table'[Name2]
)
)
RETURN
[Value]/_equal
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@ryan_mayu it did not work sadly. The primary data isn't actually pivoted; I only formatted it as a pivot table in Excel for illustration purposes. The main dataset contains thousands of individual records for each brand for each month. Is there any other way to get the percentage i want?
then pls provide the sample data
Proud to be a Super User!
Hi @ryan_mayu , i can't create a sample data as it has so much to replicate. It will be a exhausting task. I am not sure, how to handle this!
you can do the data transform(unpivot table) in pq
then create a measure
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
89 | |
76 | |
66 | |
60 |