Count on dimension in Excel sheet

How can I implement following SQL logic on importing Excel sheet in EazyBI using MDX ->

Is it possible as I am not using any pre-calculated measure ?

Can anyone please answer this.

Hi @Akash_Goel!

I’m sorry there has not been any answer so far.

If you have a custom mapping, at least one measure is a must (see more here–AtLeastOneMeasure). You can add a column with 1 for each row and that would give you a count that you can use for all other custom dimensions.

Lauma /