help COUNTX

[Inácio]

I need the Total to give me how much  "1"  there is on line

[Shravan133 · Accepted solution]

To create a measure that counts the occurrences of "1" in each row across multiple columns, you can use DAX. This involves creating a calculated column or measure that iterates over each row and sums up the values.

Assuming you have a table named YourTable with columns Column1, Column2, Column3, ..., ColumnN, here's how you can achieve this:

Creating a Calculated Column

If you want to create a calculated column to store the count of "1"s for each row, follow these steps:

1. Go to the Modeling tab in Power BI Desktop.
2. Click on New Column.
3. Enter the following DAX formula:

CountOfOnes =

VAR RowData = { YourTable[Column1], YourTable[Column2], YourTable[Column3], ... , YourTable[ColumnN] }

RETURN COUNTX(

FILTER(

 RowData,

 [Value] = 1 ),

 [Value] )

Replace Column1, Column2, ..., ColumnN with the actual column names of your table.

Creating a Measure

If you prefer to create a measure that calculates the count of "1"s dynamically, follow these steps:

1. Go to the Modeling tab in Power BI Desktop.
2. Click on New Measure.
3. Enter the following DAX formula:

TotalCountOfOnes =

SUMX( YourTable,

VAR RowData = { YourTable[Column1],

 YourTable[Column2], YourTable[Column3], ... , YourTable[ColumnN] } RETURN

COUNTX( FILTER( RowData, [Value] = 1 ),

 [Value] ) )

Replace Column1, Column2, ..., ColumnN with the actual column names of your table.

[Ashish_Mathur · Accepted solution]

Hi,

You havenot shared much information so my measure is pure guesswork.  Try this measure

Measure = countrows(filter(values(Hora[Hora]),[measure1])

Measure1 is the measure you have written which returns 1's.

Hope this helps.

[v-jtian-msft · Accepted solution]

Hello,@Ashish_Mathur and @Shravan133 ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hi,@Inácio .I am glad to help you.
Here is my test:

Correct Measure:

Measure_result = 
COUNTX(
    SUMMARIZECOLUMNS(
        'Table'[Type],
        'Table'[Date]
    )
    ,[Measure 2])
    //change the [measure 2] to your own measure

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[Ashish_Mathur · Accepted solution]

Hi,

You havenot shared much information so my measure is pure guesswork.  Try this measure

Measure = countrows(filter(values(Hora[Hora]),[measure1])

Measure1 is the measure you have written which returns 1's.

Hope this helps.

[Shravan133 · Accepted solution]

To create a measure that counts the occurrences of "1" in each row across multiple columns, you can use DAX. This involves creating a calculated column or measure that iterates over each row and sums up the values.

Assuming you have a table named YourTable with columns Column1, Column2, Column3, ..., ColumnN, here's how you can achieve this:

Creating a Calculated Column

If you want to create a calculated column to store the count of "1"s for each row, follow these steps:

1. Go to the Modeling tab in Power BI Desktop.
2. Click on New Column.
3. Enter the following DAX formula:

CountOfOnes =

VAR RowData = { YourTable[Column1], YourTable[Column2], YourTable[Column3], ... , YourTable[ColumnN] }

RETURN COUNTX(

FILTER(

 RowData,

 [Value] = 1 ),

 [Value] )

Replace Column1, Column2, ..., ColumnN with the actual column names of your table.

Creating a Measure

If you prefer to create a measure that calculates the count of "1"s dynamically, follow these steps:

1. Go to the Modeling tab in Power BI Desktop.
2. Click on New Measure.
3. Enter the following DAX formula:

TotalCountOfOnes =

SUMX( YourTable,

VAR RowData = { YourTable[Column1],

 YourTable[Column2], YourTable[Column3], ... , YourTable[ColumnN] } RETURN

COUNTX( FILTER( RowData, [Value] = 1 ),

 [Value] ) )

Replace Column1, Column2, ..., ColumnN with the actual column names of your table.