excel - display measure on pivot table with different fields under "column" area

[Anonymous]

hi guys,

i've calculated a measure "N mod" = DISTINCTCOUNT(Tabella_EstrazioneMateriali[Modello]) and then add that measure on values of pivot table in excel.

> Pivot table:

What i'm trying to achieve is to display a calculated column "Fabb n." with values to be grouped by "Unità di misura" on columns and the values of the measure "N mod" not grouped under "Unità di misura" but in 1 column as you can see in the screenshot below:

I'm new to power pivot and i'm wondering if there is a formula for that measure that can help me. thanks in advance

ex. in short, the data of pivot table is structured as:

MATERIALE	MODELLO	FABBISOGNO	UNITA' DI MISURA
rope	A	10	m
rope	B	1	m
steel	A	3	kg

[Greg_Deckler]

Sample source data would be great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

https://1drv.ms/x/s!AlibJbtIbDxpiMhliKl54OsEO7zhlA?e=vc8vBT 

The data is on sheet "Estrazione Materiali" and is retrieved from a sql istruction with dynamic parameters, then is loaded to the Power Pivot data model;

The pivot table to focus on is on sheet "pivot materiale-modelli" and the measure is called "N mod"

[Anonymous]

Hi @Anonymous ,

I just trying to open the link, but it failed with error message "can't load the excel sheet..."... Could you please upload the sample data (exclude sensitive data) and expected result to OneDrive for Business?

Best Regards

Rena

[Anonymous]

here's the updated link with a zipped folder so the file won't be opened on excel online because it will get an error 

https://1drv.ms/u/s!AlibJbtIbDxpiMhqs7zoK967Lkfytg?e=wiyATc