@Olamum In Power BI, you can easily calculate the count of "True" values for each row using the DAX (Data Analysis Expressions) language.
Follow these steps to achieve the desired result:
Step 1: Load your data into Power BI:
Ensure that your data is loaded into Power BI, and the columns are appropriately named.
Step 2: Create a New Column for Counting "True" Values:
Go to the Power BI Data View. Right-click on your table, then select "New Column" from the context menu. Name the new column, for example, "TrueCount."
Step 3: Write the DAX Expression:
In the formula bar, write the DAX expression to calculate the count of "True" values for each row. The expression uses the functions `IF` and `COUNTROWS` to achieve this. Assuming your table is named "YourTable," and the columns are named "Change_1," "Change_2," and "Change_3," the DAX expression would be:
```DAX
TrueCount =
COUNTROWS(
FILTER(
YourTable,
[Change_1] = TRUE() ||
[Change_2] = TRUE() ||
[Change_3] = TRUE()
)
)
```
Step 4: Apply the Expression:
Press Enter to apply the DAX expression. Power BI will calculate the "TrueCount" for each row based on the conditions specified.
Step 5: Check the Results:
Navigate back to the Power BI report view, and you should see a new column named "TrueCount" displaying the count of "True" values for each row in your table.
Now, your Power BI report should display the desired count of "True" values for each row, as you described:
- First row result = 2 because "True" appears twice.
- Second row result = 1.
- Third row result = 3.
You can then use this "TrueCount" column in your visualizations or further analysis as needed.
