request
4 TopicsCustomization of access request instructions
I think we should be able to fully customize the instructions a user receives when attempting to access an app / report. We should be able to direct users elsewhere instead of just receiving the default email from MS requesting access. Along with this, the emails received from MS should also be standardized whatever the access request is for. Some have the users email, some do not. This way automations could be used to auto reply to the user requesting access.1.1KViews0likes0CommentsMeasure with multiple conditions
Hello, just getting back to power bi after a while, and I have the following problem and data: I have this table as if a register table Client Id Client Name Charge? Minimum Monthly Value 1 A Yes 1000 1000 2 B Yes 2000 0 3 C No 3000 0 4 D Yes 0 0 5 E Yes 0 2000 And this table as if a transactions table Client ID Client Name Value 1 A 500 1 A 200 2 B 1500 2 B 700 3 C 300 4 D 200 5 E 100 5 E 300 For those who have Charge? = Yes, then I should see if they have a Minimum value. If they do, when the transactions SUM > Minimum, then I should Charge the SUM value. If SUM < Minimum, then I should Charge the Minimum. Also if they have a monthly value I should add it to this result (SUM+Monthly or Minimum+Monthly). If I dont have a Minimum, them I should just Charge the SUM+Monthly if they have it or just the SUM. With these examples and rules, I want the following results: I want how much I should charge for each client for those who have Charge? = Yes, so something like: A 2000 B 2200 C 0 D 200 E 2400 I want the sum of all charges, so something like: 6800 And I want to show how much im charging for each charge type, so something like: Transactions 2800 (only the values that passed the minimum) Minimum 1000 (only the case when transactions<minimum) Monthly Value 3000 I used this examples since I cant share my original data, but its a loooot of transactions, so using measures that would be more fluid would be better!! Thank you in advance!!!Solved971Views0likes4Comments