Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
4 years ago
Solved

How do I create a Dynamic Report Title for the possible scenarios?

I am working with the following data: Area Values A 45 B 34 C 87 D 56 E 97 F 34 G 21   I have plotted a simple bar chart to illustrate this data. I would lik...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  HamidBee ,

    Here are the steps you can follow:

    1. Create measure.

    1&&7 =
    var _discount=DISTINCTCOUNT(Data[Area])
    var _max=MAX('Data'[Area])
    return
    SWITCH(
        TRUE(),
        _discount=7,"Total Number of Transactions",
        _discount=1,"Total Number of Transactions in Zone"&" "&_max)
    2&&6 =
    var _discount=DISTINCTCOUNT(Data[Area])
    VAR _area = CONCATENATEX(
    VALUES(Data[Area]),Data[Area],",")
    var _len=LEN(_area)
    var _replace=
    REPLACE(_area,_len-1,1,"&")
    return
    "Total Number of Transactions in Zones " & _replace & ""
    True =
    var _discount=COUNT(Data[Area])
    return
    IF(
        _discount in {1,7},[1&&7],
        [2&&6])

    2. Result:

    Sovle1:

    Sovle2:

    Solve3:

    Solve4:

     

    Best Regards,

    Liu Yang

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