DAX

[nabilassellalou]

  I have a data table on several columns, I want to count the number of "yes" rows for a single M1 and M4 for the same identifier, because there are several M1 and M4 which are repeated for the same identifier.

[Greg_Deckler]

@nabilassellalou Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[nabilassellalou]

https://docs.google.com/spreadsheets/d/186-uW7bnUgvSOE1t3NLTqt802rqGAsOP/edit?usp=drive_link&ouid=10..., https://drive.google.com/file/d/1eO76mjn8j7ASfnaNToSKxox85RDDf395/view?usp=drive_link

[ryan_mayu]

you can try to use the ALLEXCEPT

https://learn.microsoft.com/en-us/dax/allexcept-function-dax?wt.mc_id=DP-MVP-5004616

It's better to provide some sample data and expected output.