Help with total number of column that have a specific value

[Human]

Hi,

I have a table that I need to calculate the total number of tanks that was active for the day either by dax or calculated column. These tanks are represented by each column and the active state is signified by the value of (1). So, for example, for 15/8/2023 should have 4 active tank since there are 4 column that have the value (1) registered. I've tried to sum up by rows but it was inaccurate as the active state for the tanks was not always aligned.

Any help is much appreciated.

[thuoc115]

You standardize the data type

[Human]

Thank you for your reply @thuoc115 but I'm not sure how to do that as I am fairly new to Power BI. But I found another solution to the problem by referring to this post = https://community.fabric.microsoft.com/t5/Desktop/Power-Query-count-columns-with-specific-values/td-... . I unpivot the related column on Power Query and used DISTINCTCOUNT on the attribute (tanks) on the Report View and it display what I wanted properly.