Forum Discussion

Arjun_reddy's avatar
Arjun_reddy
Icon for Helper I rankHelper I
3 years ago
Solved

dax query

Hi Community team,   I need you help on build dax query for second largest retail channel on total sales I am sharing the code for first largest retail channel  on total sales  1largest_TotalCha...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

    https://1drv.ms/u/s!AiUZ0Ws7G26RihMKgrmog1QqoECj?e=OQNfR6

     

    If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

Share sample pbix file to help you.

Arjun_reddy's avatar
Arjun_reddy
Icon for Helper I rankHelper I
3 years ago

Please find the below data table

categoryyearsales
chairs20215000
tables20216000
bulbs20226000
sofa20224500
chairs20228000
chairs20216000
chairs20212800
sofa20224700
bulbs20222000
sofa20215500
tables20216000
tables20223400
bulbs20214000
  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    you can show what result you expect

    • Arjun_reddy's avatar
      Arjun_reddy
      Icon for Helper I rankHelper I
      3 years ago

      result should be have as mentioned rounded yellow color in snap

      • Ahmedx's avatar
        Ahmedx
        Icon for Super User rankSuper User
        3 years ago

        Is this what you are looking for?