Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with Line chart

Hi All,   I have to use a Line chart to show the sales unit by the date and when we select multiple stores then every store shows by separate color(Legend) as shown below: Expected Result: B...
Need Help
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try this:

AllSelected =
IF (
    CALCULATE ( DISTINCTCOUNT ( Sales[Store] ), ALLSELECTED ( Sales[Store] ) )
        < CALCULATE ( DISTINCTCOUNT ( Sales[Store] ), ALL ( Sales[Store] ) ),
    SUM ( Sales[Quantity] ),
    CALCULATE ( SUM ( Sales[Quantity] ), ALL ( Sales[Store] ) )
)

Hope this helps.

 

Best Regards,

Giotto

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    No, It shows the same result as previous.

     

    It is not working