Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I am brand new to this forum so forgive me if I missed something. Here is my issue:
Within power bi I have formed a report which is simply (initially) a count of claims per Pharmacy Chain. The report looks like this:
I sorted the list intentionally by "Count_of_Claims_Paid" (a measure) to underscore my issues. Now all I want to do is to retreive the maximum value of this measure in order to compare each ChainName against the that maximum value. I have tried literally everything from summarized tables, various groupings all to no avail as quite often the maximum Im finding is simply the count_of_claims for that same rows which is obviously incorrect. I simply want to retreive the value (in the context of the posted image which is sliced by month and year) which in this current context is 520736. The only simply way I could find was this:
Solved! Go to Solution.
Hi Amit, I actually tried your second formula:
Correction folks the actual answer is this:
Hi everyone,
I think the most accurate solution is the following:
Max_Count_Of_Claims_Paid: = VAR ValuesDisplayed =
CALCULATETABLE(
ADDCOLUMNS(
SUMMARIZE(Claim,Provider[ChainName],Claim_LastUpdate[year],Claim_LastUpdate[MonthName]),"@Claim_Count", Claim[Count_Of_Claims_Paid]),
ALLSELECTED()
)
VAR MAXVAL=MAXX(ValuesDisplayed,[@Claim_Count])
return MAXVAL
@Brycert , Refer if these two can help
https://windowsreport.com/memory-error-allocation-failure/
Check formula like this
Max_Count_Of_Claims_Paid =
MAXX(Summarize((Claim_partition_v1), Claim_partition_v1[chain_name],Claim_partition_v1[Month name],Claim_partition_v1[year],"_1",Claim_partition_v1[Count_Of_Claims_Paid]), [_1])
or
Max_Count_Of_Claims_Paid =
MAXX(Summarize(All(Claim_partition_v1), Claim_partition_v1[chain_name],Claim_partition_v1[Month name],Claim_partition_v1[year],"_1",Claim_partition_v1[Count_Of_Claims_Paid]), [_1])
Thank you folr your prompt reply. I should have said that the chain name is coming from a table called "Provider" and the "Month" and "year" columns are coming from a "Datedim" table. How would the calculation be changed knowing this?
Correction folks the actual answer is this:
Hi Amit, changing the measure to reflect the correct table names, namely this (per your suggestion) i.e.
So the grand total is correct, just not the individual rows.
Hi Amit, I actually tried your second formula:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |