Issue Creating Measure Groups

I created a measure group to organize my data model. (see picture)

  1. Key Measures
  2. Time Comparison

When I went to apply the changes and those were the only ones I receive an error. I have had this happen before. Trying to determine why…

image

image

Hi @mbraun,

You might be getting error because you might not have any column in the table. You must have 1 column in the table and then load it you will not get error. After loading when you move 1 measure inside it then you can delete the column.

  1. Enter Data and name the table have 1 column.

  2. After Loading.

image

3.Right Click on Column1 and delete it.

image

4.You will get as below.

image

@MK3010,

One small recommended tweak to your response above. In Step 3, instead of selecting “delete” for Column 1, select “hide”.

The reason is that if you use external tools to document and analyze your model (such as my favorite - Monkey Tools), if you delete Column 1, the tools may no longer recognize that table, but they will if you just hide it.

Even if you don’t use any of these tools currently, I think “hide” is the best approach since it still preserves your option to use them in the future.

  • Brian

Hi @BrianJ,

Thank you I got it. Will keep it in mind.

But if user wants to display Measure symbols then he/she needs to have only measures in that group.

image

@MK3010,

Hiding Column 1 still gives you the Measure symbol, and puts the Measure Tables at the top of the field list:

image

  • Brian

@BrianJ, my apologies I had not tried it. Now you showed me I will follow your way. :pray:t2::slightly_smiling_face:

All @BrianJ @MK3010 both of you thanks for your quick response. I was able to fix it based on your suggestions. Had that moment of panic thinking I was going to have to rebuild the whole data model.