Forum Discussion

firstch's avatar
firstch
Icon for Helper III rankHelper III
4 years ago
Solved

please Help Dax for smart narrative

I really need help for using function concatenatex for the top 3 value for smart narrative  how to solve  this  error smart narrative, i try to show top 3 country by total value but the countr...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi， firstch ；

    You could change it such as:

    rank = 
CONCATENATEX (
    FILTER (
        ALLSELECTED ( 'financials'[Country] ),
        RANKX (
            ALL ( financials ),
            CALCULATE ( [total], ALLEXCEPT ( financials, 'financials'[Country] ) ),
            ,
            DESC,
            DENSE
        ) <= 3
    ),
    'financials'[Country],
    ",",
    [total], DESC
)

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, firstch ,

    You could try it.

    rank = 
CONCATENATEX ( FILTER( ALLSELECTED( 'Table'),[product]=MAX([product])&&
        RANKX (
            FILTER( ALLSELECTED ( 'Table'),[product]=MAX([product])),
            CALCULATE ([Total]),
            ,
            DESC,
            DENSE
    )
   
 <= 3
    ),
   'Table'[country],
    ",",
   [Total], DESC
)

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi， firstch ，

I test your data, the result as below:

rank = 
CONCATENATEX (
    FILTER (
        ALLSELECTED ( 'Table'[country] ),
        RANKX (
            ALL ( 'Table'),
            CALCULATE ([Total], ALLEXCEPT ( 'Table','Table'[country]) ),
            ,
            DESC,
            DENSE
        ) <= 3
    ),
    'Table'[country],
    ",",
   [Total], DESC
)

The final show:

Or what the result you want to output?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • firstch's avatar
    firstch
    Icon for Helper III rankHelper III
    4 years ago

    Hi v-yalanwu-msft 
    could you please include slicer with  product carbon ,output it might concat all country as picture 
    the real output that i want is concat top 3 country name althrough it have only 2 country that have that product
    best regard
    firstch