Forum

Table or Matrix wit...
 
Notifications
Clear all

Table or Matrix with complicated measures - how to associate measure with a particular row instead of entire column listing.

2 Posts
2 Users
0 Reactions
63 Views
(@rickert)
Posts: 7
Active Member
Topic starter
 

Hello!

I am trying to build a table to display current % progress for Construction.  For example: Category of Baselay consists of mutliple subcategories: timber-felling, ECDs, stringing, welding, etc.  and each of those sub-categories will have a % progress summed.  I already have the measures calculated and the results are correct; however, I cannot seem to figure out how to get that data to display properly.  It needs to look something like this:

Category       % Progress

Timberfelling: 34%

ECDs: 50%

Welding: 15%

 

But I get a display like this:

Category         Timberfelling %    ECD %    Welding %

Timberfelling   34%                     50%          15%

ECDs              34%                     50%          15%

Welding          34%                     50%          15%

 

I'm trying to wrap my head around this and I'm pulling my hair out instead. lol 

The % progress is a measure I have created. The measure is not yet dynamic.  Currently, my measure for timberfelling looks like the following: 

ActualTimberFelling = CALCULATE([WeeklyProgressSum],ALLSELECTED(ProgressMini),ProgressMini[Week Ending]<=MAX(ProgressMini[Week Ending]),ProgressMini[SeriesType]="Act",ProgressMini[Construction SubCategory]="Timber Felling")
 
The 'Act" of SeriesType stands for 'Actual' as in Actual progress.
 
The "Weekly Progress Sum" is a column containing percentage completion by Week Ending and contains multiple categories where the data is not broken out.  Summing % gives me 3000% which of course is wrong, lol.  So using measures allows me to breakdown the categories and obtain the correct current % complete for that category. However, I need to figure out how to display the data.
 
Do you have any suggestions? I've been watching multiple videos but nothing seems to help.
 
I have attached a sample file.  It's fake data.  I'm trying to show the current progress as of 4/26/23 for all categories in a matrix or table so that management can see a listing of progress.
 
Thanks so much for your suggestions!! Laugh
 
Posted : 09/08/2022 6:09 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Valerie,

Please try uploading the sample file again. After selecting the file, click the Upload button and wait for the grey check mark beside the file size before pressing the Submit Reply button.

Mynda

 
Posted : 09/08/2022 8:36 pm
Share: