Calculating Value based on Filters in Dax

[ashicool_10061]

Hi There,

I am trying to create a measure where i am counting number of rows anf filtering the table with a column.

However as soon as i am doing it i am encountering error WHICH Is mentioned below:

Measure=calculate(countrows(iterm code),filter(table,Process name))

Can you please help me in achieving the same result?

Thanks,

ashish

@SamWiseOwl 

[ashicool_10061]

Hi @marcelsmaglhaes ,

It worked the way you told. Appreicate your help.

Thanks,

Ashish

[marcelsmaglhaes]

Hey @ashicool_10061 ,

The issue you're encountering is because you're trying to use a column in the filter that isn’t a Boolean expression. In your case, you're attempting to filter the table using just the column name (Process name), which is causing the error. You can fix the measure by ensuring the filter condition is properly defined:

Measure =
CALCULATE(
COUNTROWS('item code'),
FILTER('table', 'table'[Process name] = "Some Value") -- Replace "Some Value" with the actual value you want to filter on
)

However, based on your example, I believe you might be able to simplify the measure like this:

Measure = COUNT('table'[Process name])

[ashicool_10061]

Hi @marcelsmaglhaes ,

I have tried themeasure wheere you have mentioned to replace "Some value" with the value which i want
Measure =
CALCULATE(
COUNTROWS('item code'),
FILTER('table', 'table'[Process name] = "Some Value") -- Replace "Some Value" with the actual value you want to filter on
)

however if i will do this then it will be for particular process name however i need a dynamic or count of each process name present in that table .

Also if i will do the Count([process_name}) then it will give me the count of all values present there like "5" if i will take process name .

I want output as

Process name         Item code
ABC                                 5
BCD                                 3                                 

IS there any way we can do this ?

Thanks,

Ashish

[marcelsmaglhaes · Accepted solution]

@ashicool_10061 

 If you're trying to count the number of process names, for example, if your table has five rows with 'ABC', you can simply count the process names, which would give you a total of 5. You can do this using count(Table[processname]) or count(table[itemcode]). 

Apologies if I misunderstood, but could you clarify what you're referring to?