Explain measure

[loxam98581]

Hi,

I was tasked with migrating our old Qliksense reports to Power BI and having trouble understanding what some of the measures are doing.

Can somebody explain what does this do?

Sum({<[Reject Name]=,[Reject Type]= >}TOTAL<[Item category],[Item Model],,Year,Month,Week,Date,[Year-Month],[Year-week],[Y-M],[Operator ID],[Warehouse Code]>Qty)

Some of the fields are from the same table where 'Qty' resides, some are from others.

To me, this looks like an overcomplicated 'Sum(Qty)'

[kaushiknsolanki]

Hi It means that you will get the total qty at the level of the defined dimensions i.e. [Item category],[Item Model],Year,Month,Week,Date,[Year-Month],[Year-week],[Y-M],[Operator ID],[Warehouse Code] ignoring the selections done in the [Reject Name],[Reject Type] fields.

[loxam98581]

Hi Thanks for the explanation.

I guess the next question would be, what "defined dimensions" mean in Qlik? I can see the dimensions on the report, but they have no filters or anything that can be changed.