Count on dimension in Excel sheet

How can I implement following SQL logic on importing Excel sheet in EazyBI using MDX ->
"SELECT count(*), FROM GROUP BY "

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 https://docs.eazybi.com/eazybi/data-import/data-mapping#DataMapping-Rule#1–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 / support@eazybi.com