Forum Discussion

ovinasca's avatar
ovinasca
Frequent Visitor
8 years ago
Solved

Measure aggregated based on dimensions

Hi all!   I need to create a measure that aggregates based on dimensions, I mean, when its aggregated by the Time Dimension I need to SUM the values but when its aggregated by the Department Dimens...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    ovinasca

     

    Hi, try with this Measure in Values Section

     

    Measure =
IF (
    HASONEVALUE ( Table1[TIME] );
    SUM ( Table1[FTE's] );
    AVERAGE ( Table1[FTE's] )
)

    Regards

     

    Victor

    Lima - Peru

     

     

     

ovinasca's avatar
ovinasca
Frequent Visitor
8 years ago

Thanks Vvelarde I will try tomorrow, I think i will work for that specific example, but if I have other dimension?

 

 

Not sure....

 

I will tell you !!!!

 

THANKS!

ovinasca's avatar
ovinasca
Frequent Visitor
8 years ago

Hi Vvelarde!! 

 

Works only for the suggested example, I mean, working only with two dimensions but works for me!

 

So thanks!!