Forum Discussion
DAX Calculation - Scaling Value based on Sum(Value) in same Column
Hi, I have a dataset containing cars with several measurements (example: number of honks). The honks are measured at different times and then summed. I now want to scale the number of honks depen...
Hi Anonymous,
thank you for your reply. You almost got my problem but my issue is that the kilometer and the honks values are in the same column and only distinguished by another column measurement_category.
I am sorry I am unable to attach the PBIX file here for some reason. I have this screenshot instead:
The value for the cell marked in yellow should be 0,96. As mentioned above, the Scaled_Value column is mocked up in Excel and not available in the real data set.
Thanks for your help!