Forum Discussion

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago
Solved

Not sum but original value despite multiple entries

Hi,   I have column chart where I would like to add "Amount" on X - axis and on Y - axis it will be Full Name and Intitution Name. Please see table below,   When i create column chart to ma...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi damit23183 ,

    Thank you for providing the details. Based on your explanation, the issue isn't with the hierarchy, but with how Power BI calculates the Amount when drilling into AB. Since only $500 appears instead of both $620 and $500, it seems Power BI is aggregating at the Full Name level and not keeping Institution Name in context.

     

    To resolve this, you can create a measure as follows

    Amount by Institution =
CALCULATE(
    SUM(Data[Amount]),
    ALLEXCEPT(Data, Data[Full Name], Data[Institution Name])
)

     

    This will ensure the Amount is calculated for each Institution Name under each Full Name. With this measure, drilling into AB will display two bars—$620 for Original and $500 for Old.

    Be sure to use this measure in the Values field of your column chart, not the raw Amount column. This should provide the breakdown you expect.

    FYI:

     

    I have attached the PBIX file for your reference. If you continue to notice any issues, please let me know and I will be happy to help further.

     

    Regards,
    Yugandhar.

FritsOrdelman's avatar
FritsOrdelman
Frequent Visitor
1 year ago
To display the original value of a field in Power BI — even when there are multiple entries — without aggregating (like summing), you can use the DAX function SELECTEDVALUE().
This function returns the value only if there is a single unique value in the current context. If there are multiple values, it returns a fallback (e.g. a message or blank).
 
OriginalValue = SELECTEDVALUE(Table[Column], "Multiple values")
 
This will:
  • Show the original value if only one exists.
  • Show "Multiple values" if there are several different values in the context.
This approach avoids automatic aggregation and ensures your visual reflects the actual value when appropriate.
  • damit23183's avatar
    damit23183
    Icon for Microsoft Employee rankMicrosoft Employee
    1 year ago

    Thanks for your response.

     

    In the logic you given, what is Multiple Values?

     

    I didnt understand how will this fit into Measure.

     

    Thanks,