Hello,
I have trouble with a DAX measure in a pivot Table that uses a Power Pivot Model.
I am trying to create a measure in my pivot table that will disply a list of PN and VC based on a PN-VC concatenate (which is the primary key of the table).
I start by creating a pivot table based on my power pivot model:
then I create a measure and my formula seems to be okay:
but then, after I click "ok", this is the pivot table that I get:
and when I try to add the VC column in the summarize, I get another error message:
what I am ultimatly trying to do is display my power pivot tables into 1 table in excel so that my users can view it (refer to: http://www.mrexcel.com/forum/power-bi/884932-user-view-power-pivot.html)
anyone know what the problem is ?
P.S.: I have Excel 2010
I have trouble with a DAX measure in a pivot Table that uses a Power Pivot Model.
I am trying to create a measure in my pivot table that will disply a list of PN and VC based on a PN-VC concatenate (which is the primary key of the table).
I start by creating a pivot table based on my power pivot model:
then I create a measure and my formula seems to be okay:
but then, after I click "ok", this is the pivot table that I get:
and when I try to add the VC column in the summarize, I get another error message:
what I am ultimatly trying to do is display my power pivot tables into 1 table in excel so that my users can view it (refer to: http://www.mrexcel.com/forum/power-bi/884932-user-view-power-pivot.html)
anyone know what the problem is ?
P.S.: I have Excel 2010
Last edited:
