How to use Measure to calculate yes and no in column

[hashmi1977]

Need to calculate yes and no in columns by using measure or any other method

Here is the actual table view:

Where we need Power Bi output like this:

[v-nuoc-msft · Accepted solution]

Hi @hashmi1977

@DataNinja777 Thank you very much for your prompt reply. I think your response is appropriate.

I found your post while reviewing the forum posts. May I ask if your problem has been solved?

If you still have questions, here I explain some of them to you.

With unpivot you are not generating a new table, you are converting the data that was in the rows, to data in the columns.

You can view the link below for more details:

Unpivot columns - Power Query | Microsoft Learn

For the table in the screenshot, you need to manually create a matrix visualization object.

Regards, 

Nono Chen 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[DataNinja777]

Hi @hashmi1977 

You can achieve your required output in many ways, but one example is to use the unpivot and countrows, as shown in the example below.  (Sorry the order of the field is in alphabetical order and do not match with your example.)  

I attach the pbix file as an example.  

[hashmi1977]

I have a sharepiont list as table and When I tried to "Unpivot Only Selected Columns" then it is not creating seperate table as I can see in your screenshot. it is unpivot rows in the same dateaset which means rows increased by (No of rows * unpivot columns)