column percent
1 Topic
dax for % answering YES in column
Apols for this simple question - i have been away from Dax for a few weeks and can't figure out, but I would like to convert table below: Q1 North Yes South No North Null West Yes South No to show the percent of Yes for each region. Like a crosstab in spss but just % answering yes for each question and aggregated by region. It would ideally look something like: Q1 % answering Yes North 50 South 30 East 75 West 30 Is there an easy way to do this? I managed myself using 3 different measures to come up with % Yes (e.g. count yes, count no, sum yes+no, % yes is no yes/total), but I have around 50 questions (so wld require 150 measures) and was wondering if there is a quicker way. I.e. is there one measure I can do per column to capture % yes? Many thanks, ASolved1.1KViews0likes4Comments