Dax calculation to filter out values basis on scenarios given in the same table

Anonymous — Thu, 19 Jan 2023 08:41:31 GMT

Hi everyone,
I have a table_1 which has columns ( qty, procurement,week)
so under qty there are values, Under procurement we have different categories (1,2,3,4). Under week we have ( week 1-20)
So I have to create a measure to get a value when,
[( Values from qty which are of 2nd category only and week from 11-16 only (subtract) Values from qty which are of 4th category and week from 11-16 only ( divide) Values from qty which are of 2nd category only and week from 11-16 only ]
Pardon me If I am not conveying it in proper way as I am new to the community and powerbi.
Thanks
amitchandak

Re: Dax calculation to filter out values basis on scenarios given in the same table

FreemanZ — Thu, 19 Jan 2023 08:51:57 GMT

hi Anonymous

try like:

Measure = VAR _value1 = CALCULATE( SUM(TableName[qty]), TableName[Procurement]=2, TableName[week]>=11, TableName[week]<=16 ) VAR _value2 = CALCULATE( SUM(TableName[qty]), TableName[Procurement]=4, TableName[week]>=11, TableName[week]<=16 ) RETURN DIVIDE(_value1 - _value2, _value1)

topic Dax calculation to filter out values basis on scenarios given in the same table in DAX Commands and Tips

Dax calculation to filter out values basis on scenarios given in the same table

Re: Dax calculation to filter out values basis on scenarios given in the same table