What-If Parameter to control delta values greater than

[Anonymous]

Hi,

Does anyone can help me on below where I can use what-if parameter to control delta values of selected SalesPerson and between his ProductSold? Thanks

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Create two measures as below. Use Flag measure as a visual-level filter on the table visual and set show items when the value is greater than 0.

Delta = 
VAR _minSold = CALCULATE(MIN('Table'[UnitsSold]),ALLEXCEPT('Table','Table'[SalesPerson],'Table'[ProductSold]))
VAR _maxSold = CALCULATE(MAX('Table'[UnitsSold]),ALLEXCEPT('Table','Table'[SalesPerson],'Table'[ProductSold]))
VAR _delta = _maxSold - _minSold
RETURN
_delta

Flag = [Delta] - [DeltaUnitsSold Value]

Attach the pbix for you to check the details.

I don't deal with the condition if there are 3 lines of ProductSold for a SalesPerson. Its expected result seems ambiguous. For example, if James has 3 lines data for Cable: 1, 11, 13. There are 3 delta values: 10, 12, 2. When setting DeltaUnitsSold as 10, only 12 is greater than it so the lines with 1 and 13 should display. But 10 and 2 is not greater than 10 so all related 3 lines should not display. I don't know how to deal with this.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[parry2k]

@Anonymous what happens if there are same sales person and product sold has 3 line items? Define how to calculate the delta?

[Anonymous]

@parry2k , I didnt thought about that. But i guess if there are 3 lines of ProductSold then get whichever the two delta which is greater than 10 or user selection