cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## help COUNTX

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

3 REPLIES 3
Community Support

And I would like to share some additional solutions below.
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.

Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Solution Specialist

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.