Forum Discussion

vimina's avatar
vimina
Frequent Visitor
3 years ago

Condition format one measure using another

I have two measure 'Sum of INCIDENT_COUNT' and 'Average', I am trying to condition format one based on another and also would like to display a like emoji

The context is to compair the value You and Average. You display the sum of incident for an employee and average shows the average no of incident. Both the measure are displayed in card visual in the report. For instance, the above visual should be displaying 4 in red color with a like emoji. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi vimina,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng