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 am new to Power BI and I am just getting my head in it so I apologise in advance if this is a silly question. I have created 4 measures (one counts the number of 1s in a column, measure 2 counts the number of 2s etc and it carries on until number 4 eg Measure 1 = CALCULATE(countrows(table1),table1[col1]="1"). The aim is to show a stacked percentage chart. In the measure the field is hard coded as Col 1. Is there anyway of to change this so that uses the field selected or am I getting the whole idea confused?
Solved! Go to Solution.
To count number of rows dynamically based on your selected fields, you can use ALLSELECTED() function without specifying columns. It will determine your selection to filter the table.
For better understanding of ALLSELECTED(), please see: Understanding ALLSELECTED
Regards,
To count number of rows dynamically based on your selected fields, you can use ALLSELECTED() function without specifying columns. It will determine your selection to filter the table.
For better understanding of ALLSELECTED(), please see: Understanding ALLSELECTED
Regards,
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |