Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm having problems with creating dynamic bins based on Medical Paid amounts.
In this snapshot, I want the values in the chart on the right to reflect the Range in the table on the left.
What seems to be happening is that the chart is ignoring a date range slicer. Range and Medical paid in the table are correct.
However the chart looks to be using the total value (Medical Filter).
The chart on the left should reflect the Range and Medical Paid based on the Reporting Date Filter.
The chart values should be 24 <25K, 1 25<50K, 0 50 < 76K, and 2 for 100K
This is critical to solve as we have a lot of custom bins we want to use.
Here are the DAX measures
MedicalPaid = CALCULATE(SUM(vMedicalClaims[AmountPaid]),DATESBETWEEN(vMedicalClaims[ReportingPaidDate],[ReportPeriodStart],ReportingDate[ReportingPeriodEnd] ))
Range = var temp=calculate(vMedicalClaims[MedicalPaid]) return
if(temp<25000," <25K",if(AND(temp>=25000,temp< 50000)," 25 to <50K",if(AND(temp>=50000,temp<75000)," 50 to <75K",if(AND(temp>=75000,temp<100000)," 75 to <100"," 100K"))))
Range of Paid = vMember[Range] --- This is a calculated column so I can use in the chart.
HI @jasonbakersd,
Current power bi not support to create a dynamic calculate column/table based on slicer, you need to use measure to instead.
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.
BTW, current measure not support to use as legend field.
Regards,
Xiaoxin Sheng
Thanks Xiaoxin it's good to know that the column is not able to support dynamic values. I do need a solution to solve the binning/chart rendering; perhaps creating a table in DAX is the way to go.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |