cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fallengoose
New Member

Make the field in a measure change to the field selected

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?

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft
Microsoft

@fallengoose

 

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.

 

6.PNG

 

77.PNG

 

888.PNG

 

For better understanding of ALLSELECTED(), please see: Understanding ALLSELECTED

 

Regards,

View solution in original post

1 REPLY 1
v-sihou-msft
Microsoft
Microsoft

@fallengoose

 

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.

 

6.PNG

 

77.PNG

 

888.PNG

 

For better understanding of ALLSELECTED(), please see: Understanding ALLSELECTED

 

Regards,

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.