Forum Discussion

jpereztang's avatar
jpereztang
Helper I
10 years ago
Solved

Organize measures when get data from model

Hi everybody,   Anybody know how web example's owners achieve organize those metrics like this image     I used SSDTHelper but I created folders were not updated in PBI Desktop.   Thanks...
  • sdjensen's avatar
    sdjensen
    10 years ago

    Basically you will archive this if only DAX calculated measures is visible in the table. What I do when I create models is always hide all columns in my fact (values) tables - I don't need any of the columns visible I only need the columns to create relationship with my dimensions and to calculate measures.

     

    If you want to split your measures into group you can just create a custom table - "Enter Data" feature - then hide the column and create measures in this new table. You can create as many as you need.

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Basically you will archive this if only DAX calculated measures is visible in the table. What I do when I create models is always hide all columns in my fact (values) tables - I don't need any of the columns visible I only need the columns to create relationship with my dimensions and to calculate measures.

 

If you want to split your measures into group you can just create a custom table - "Enter Data" feature - then hide the column and create measures in this new table. You can create as many as you need.