Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Filled Map Conditional Formatting for aggregated amounts

Hi,    I am having issues with conditional formatting within the Azure map visual for filled color. Essentially, the table I have records shipments and whether they were on-time, early, delayed. Th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ，

 

ALLEXCEPT will ignore dimensional table slicer, remove it to check the result.

 

Most Frequent Shipment Status = 
VAR EarlyCount = CALCULATE(COUNTROWS('Table'), 'Table'[Shipment Status] = "Early")
VAR LateCount = CALCULATE(COUNTROWS('Table'), 'Table'[Shipment Status] = "Late")
VAR OnTimeCount = CALCULATE(COUNTROWS('Table'), 'Table'[Shipment Status] = "On-time")
RETURN
SWITCH(
   TRUE(),
   EarlyCount > LateCount && EarlyCount > OnTimeCount, "Early",
   LateCount > EarlyCount && LateCount > OnTimeCount, "Late",
   OnTimeCount > EarlyCount && OnTimeCount > LateCount, "On-time",
   "Early"
)

 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Joyce!

Thanks for the response. I removed the allexcept formula and it doesnt seem to be working as expected, still. 

Most_Freq_Ship_Status = 
 VAR earlycount = CALCULATE(COUNTROWS(fbm_delayed_shipements),fbm_delayed_shipements[status] = "Early")
 VAR latecount = CALCULATE(COUNTROWS(fbm_delayed_shipements),fbm_delayed_shipements[status] = "Late")
 VAR ontimecount = CALCULATE(COUNTROWS(fbm_delayed_shipements),fbm_delayed_shipements[status] = "On Time")
 RETURN
 SWITCH(
    TRUE(),
    earlycount>latecount && earlycount > ontimecount, "Early",
    latecount > earlycount && latecount > ontimecount, "Late",
    ontimecount > earlycount && ontimecount > latecount, "On-time",
    "Early"
 )

 

Any additional thoughts? Thanks!