Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

how to create a Pivot table based on the selected values from another table? - Please help

Hi, I have created a demo app and attaching the link. I want that when I select the customer ID from table1, it will show realted data in below 2nd pivot table. For this I have created a Pivot table...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    No, that is just a formula in Calculated Pivot table expression.

    In simple terms, this expression is a "calculate column formula" not a "calculate measure formula" for current context of the formula that is used to create a calculate table. 

     

    Note: calculate column and calculate table can't be affected by any slicer.

     

    Best Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

Can I use measure in Calculated Pivot table?means if I have created a measure and used it in a Calculated Pivot table like below?

Pivot Table = UNION(
SELECTCOLUMNS (
Data,
"Column Name", "Alert Category",
"Values", Data[Alert Cat measure]
),
SELECTCOLUMNS (
Data,
"Column Name", "File ID",
"Values", Data[FILE_ID_SELECTED]
)
)
 
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

No, that is just a formula in Calculated Pivot table expression.

In simple terms, this expression is a "calculate column formula" not a "calculate measure formula" for current context of the formula that is used to create a calculate table. 

 

Note: calculate column and calculate table can't be affected by any slicer.

 

Best Regards,

Lin