How to calculate measure only for come dimantions

[googlogmob]

How to make measure SUMMA = BLUNK only for dimension "Field_C"?

[Greg_Deckler]

Not enough information, please post sample data and more detail.

[googlogmob]

@Greg_Deckler, here is Sample on Google Drive

And the same on screen

[Eric_Zhang]

@googlogmob

May I know why you'd like to show the data that way, For me, I will create a calculated table as below.

Table =
UNION (
    SELECTCOLUMNS (
        'Лист1',
        "FieldGroup", "FieldA",
        "Field", 'Лист1'[Field_A],
        "Amount", 0
    ),
    SELECTCOLUMNS (
        'Лист1',
        "FieldGroup", "FieldB",
        "Field", 'Лист1'[Field_B],
        "Amount", 'Лист1'[Amount]
    ),
    SELECTCOLUMNS (
        'Лист1',
        "FieldGroup", "FieldC",
        "Field", 'Лист1'[Field_C],
        "Amount", 'Лист1'[Amount]
    )
)

[googlogmob]

@Eric_Zhang, thanks, it works

but maybe is way to realise it in SUMM  measure?
creating second table have some problem because there are many columns and measures in original project  

[Eric_Zhang]

---

@googlogmob wrote:

@Eric_Zhang, thanks, it works

but maybe is way to realise it in SUMM  measure?
creating second table have some problem because there are many columns and measures in original project  

---

@googlogmob

Could you post the whole picture of your scenario, displaying data as in your original post is not usually a best practice way.

[googlogmob]

@Eric_Zhang

Main sense is that measure SUMM must show result only for another dimansions Field_B and Field_C, and NULL for Field_A, because the calculation of the measure SUMM can not be performed for Field_A from economic rules

i.e. such logic: IF dimention = Field_A THEN null ELSE SUMM