cancel
Showing results for
Did you mean:
Highlighted
Helper III

## How to calculate measure only for come dimantions

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

6 REPLIES 6
Highlighted
Super User IV

## Re: How to calculate measure only for come dimantions

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

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Helper III

## Re: How to calculate measure only for come dimantions

@Greg_Deckler, here is Sample on Google Drive

And the same on screen

Highlighted
Microsoft

## Re: How to calculate measure only for come dimantions

@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]
)
)```

Highlighted
Helper III

## Re: How to calculate measure only for come dimantions

@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

Highlighted
Microsoft

## Re: How to calculate measure only for come dimantions

@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.

Highlighted
Helper III

## Re: How to calculate measure only for come dimantions

@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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors