Forum Discussion
Helper I% of a value...
This should be easy I'm sure of it but I can't for the life of me work it out.
As a DAX measure I want to work out the % of a number to return me that percentage of the number
If I have £100 and I want to show 5% of £100 I want my Dax calculation to show me £5
The number I am using as my % is a percentage value not a number so the value is stored as 5% in the model.
There is a drop down which choses the % level eg 2,5,7,10 and I then push this SELECTED VALUE into a Commision selected measure.
I then want to take the Commission selected value and have the 5% (etc) of a value say 100 return me the number £5
I have tried so many things I just think it must be DIVIDE (100, CommissionSelected)*100 etc., but it just does not work
Help!
Greg888 ,
Based on your description, I think you are trying to do something like this:
SelectedCommission% = SELECTEDVALUE( YourTable[Commission] )CommissionValue = Divide( [SelectedCommission%], 100 ) * [YourValueMeasure]Assuming [YourValueMeasure] = 100, then:
Trust this is what you are looking for.
Regards,
3 Replies
- rsbin
Community Champion
Greg888 ,
Based on your description, I think you are trying to do something like this:
SelectedCommission% = SELECTEDVALUE( YourTable[Commission] )CommissionValue = Divide( [SelectedCommission%], 100 ) * [YourValueMeasure]Assuming [YourValueMeasure] = 100, then:
Trust this is what you are looking for.
Regards,
Greg888That's perfect. I had to change the Commission selected value from the dropdown to be a whole Number, I will label it rather than mess around anymore storing as %.
Then when I used your formula it worked a treat 🙂Thank you so much.