Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
6 years ago

Grouping Measures

I have the following single table model: Table "PMQSDataAfrica" is a table with all data.  I then created measures from this table and grouped them in different tables as can be seen in the mo...
Need Help
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Chitemerere ,

 

Just wanted to check when you created a measure table, in the starting you must have had a single column in this measure table right?

Did you Hide this column or remove this column?

You may be getting this issue because you may have removed this one and only column from you measure table. Idellay you should hide it rather than removing it.

 

See the following article on measure tables.

https://www.biinsight.com/define-measure-table-power-bi-desktop/

 

Thanks,

Pragati

Chitemerere's avatar
Chitemerere
Responsive Resident
6 years ago

 I have recreated one of the tables to hold the measures and did not delete the created column.  I then moved the respective measures into this table and there are no errors.  However the visual is blank. Please see image below:

 Prior to this, it was not blank.  When I move back the measures to the mother table, the visual displays correctly.  In prior versions of Power BI I would delete the created column1 with no problems at all

Regards,

Chris

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Chitemerere 

     

    I wonder what the measure is like. A measure operates on aggregations of data defined by the current context. In a pivot table, for example, source tables are filtered according to the coordinates of cells, and data is aggregated and calculated using these filters.

     

    You must define a measure whenever you want to display resulting calculation values
    that reflect user selections and see them in the Values area of pivot tables, for example:


    1. When you calculate profit percentage of a pivot table selection.
    2. When you calculate ratios of a product compared to all products but keeping the filter both by year and region.

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.