Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Percentages

Hello all, I have a problem that I can not solve as a novice. I have a table with trial subsciptionas from customers. In parallel, I have joined the real subscriptions  and shown in a table, how...
DAX
Help me please
Measure Column Total
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    Hi Anonymous ,

     

    You can use the Clustered bar chart instead to achieve this goal.

    1. Create two measure trail and real

     

    trail = DIVIDE(SUM('Table'[Trail Subscription]),SUM('Table'[Trail Subscription]))

real = DIVIDE(SUM('Table'[Real Subscription]),SUM('Table'[Trail Subscription]))

     

    2. Change the format of these measure to percentage.

     

    3. Apply the two measure to the chart.

    4. Open the data label.

     

     

    Final output:

     

    If the result you want is not this, please clarify in the next reply

     

    Best Regards,

    Jianbo Li

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

kitgo2's avatar
kitgo2
Advocate I
4 years ago

 would it be possible for you to provide some sample data of both tables? I would think that you could use an If (correct subscriptions >0 ,*then* trial subscriptions - correct subscriptions, *else* trial subscriptions  then have the type as the legend