ignore Category in measure

[graceste]

Hi,

my plan values are divided in Group and Category, my results are divided in Group, Category and Subcategory

is there any way to show only Subcategories with value and plan only for Category and Group?

thanks for any help

                                                                               Value                 Plan                    Diff.

[Anonymous]

Hi @graceste,

Maybe you can try to add condition to check if current value column is not blank, then calculate with plan.

Diff =
IF (
    SUM ( Table[Value] ) <> BLANK (),
    SUM ( Table[Value] ) - MAX ( Table[plan] ),
    BLANK ()
)

Regards,

Xiaoxin Sheng

[graceste]

Hi  @Anonymous

then I will see the rows anyway, and I would like to hide them, expectet result should show Value,Plan and Diff. only for Group and Category,

Subcat. should be shown only if it has a value as info to show what builds the Category result 

	Value	Plan	Diff
Group	12.625 €	15.000 €	2375
Category	82 €	136 €	-54
Subcat.14	82 €

all other Subcat. should be hidden, it doesn't work with Value Filter because the same Subcat. are used in other Groups and they have a value there,

is there any way to achieve that?

[Anonymous]

Hi @graceste,

Can you please provide some sample data or pbix file for test and code formula?

Regards,

Xiaoxin Sheng