Forum Discussion
Get Maximum Budgets with Conditionals
Greetings, I am having difficulty getting the budgeted maximum budgets due to the following conditions.
1. the paceinte 8 has 3 treatments two already started therefore I must porder filter the payments, use this function to filter them
2. Patient 77 has not made payments needs to filter the maximum treatment of this.
The intention with this is to calculate the maximum budgeted treatments by patients, if a patient started treatments and has not started the incites will be taken, if the patient does not start any treatment will take only the maximum since I did not start any.
I try with this equation where I ask you to place 1 and 0, but it does not work when the patient has never started a treatment.
2 Replies
Syndicate_Admin In general MAXX(FILTER(...), ...) or MAXX(SUMMARIZE(FILTER(...), ...), ...) Hard to be more specific without mocking it up. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Current status
Expected
I need to be able to filter the budgets to which payments were made and if no payment is made show me the largest budget for that patient.
