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 am pretty new and Power BI and I am researching a lot but I'm having trouble creating a solution for this. I have this table in Power Query
And I'm trying to produce something like this:
I'm looking for the COUNTIFS function but I am not sure what is its equivalent in DAX. Thanks for your help.
Solved! Go to Solution.
Ok, let's take this step by step...
A) We need to unpivot the columns in Power Query. This involves
Like this:
B) Creating dimension tables for both Facility and Value field:
Like this:
Repeat the process for the "Value" field and load into the model
C) Create relationships between each field in the Dimnesion Tables and their corresponding field in the Fact table (In my example named "Facilities Table")
D) Build the matrix:
1. Create the measure to count the Values:
Count Value Measure = COUNT('Facilities Table'[Value])
2. Build the matrix using the fields from the dimension tables: dFacility in the Rows bucket; dValue in the Columns Bucket; and add the [Count Value Measure] to the values bucket to get:
I've attached the sample PBIX file
Proud to be a Super User!
Paul on Linkedin.
Ok, let's take this step by step...
A) We need to unpivot the columns in Power Query. This involves
Like this:
B) Creating dimension tables for both Facility and Value field:
Like this:
Repeat the process for the "Value" field and load into the model
C) Create relationships between each field in the Dimnesion Tables and their corresponding field in the Fact table (In my example named "Facilities Table")
D) Build the matrix:
1. Create the measure to count the Values:
Count Value Measure = COUNT('Facilities Table'[Value])
2. Build the matrix using the fields from the dimension tables: dFacility in the Rows bucket; dValue in the Columns Bucket; and add the [Count Value Measure] to the values bucket to get:
I've attached the sample PBIX file
Proud to be a Super User!
Paul on Linkedin.
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |