Commission As per Vlookup and Criteria table

[bilalkhokar73]

Dear Team,

I will be glad if soemone help me on this as I am new to thsi part

I want to make Commission based of crieteria and Vlookup from other table as this things are in % and % is hard for me
Commssion criteria sublass wise is defined in other table
Sales will come from sales table
TGT from target table
payment value from criertia table
I have attahched power bi and excel file on drop box
https://www.dropbox.com/sh/i06s3gsyugp5mc7/AAB6RZieJe2lIsV8qoJIolVQa?dl=0
@amitchandak @v-yalanwu-msft 

[Ashish_Mathur]

Hi,

Are you looking at something like this - Compute transaction fee based on a tiered pricing model.

Hope this helps.

[V-pazhen-msft]

@bilalkhokar73 

Power bi measure is based on data tables, you had data in the same table in the pbix, which is totally different case when you have multiple data table.

Please provide the actual data tables in the pbix, remember remove sensitive data.

Paul Zheng _ Community Support Team