Forum Discussion

PujaPal's avatar
PujaPal
New Member
6 years ago
Solved

VALUES getting aggregated in Power BI

Hi team, Hope everyone is doing good! I need some help to resolve the below issue:   I am using Azure Analysis Service with Power BI and I have a matrix visual with 5 fields as ROWS(ID, Name, Loc...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi PujaPal ,
    As AllisonKennedy  mentioned, Matrix is for aggregating values. We cannot show not summarize data in it directly.

    However, you can create a calculated column in your AAS model based on some conditions like rank on value1... and show them in the matrix visual to avoid aggregating indirectly.

    index = RANKX('Sheet1','Sheet1'[Value1],,DESC,Dense)

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi PujaPal ,
As AllisonKennedy  mentioned, Matrix is for aggregating values. We cannot show not summarize data in it directly.

However, you can create a calculated column in your AAS model based on some conditions like rank on value1... and show them in the matrix visual to avoid aggregating indirectly.

index = RANKX('Sheet1','Sheet1'[Value1],,DESC,Dense)

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.