Forum Discussion

haurg's avatar
haurg
New Member
3 years ago

Legend from dynamic measure

Hi,

I want to split this stacked line chart by the measure `cat`.

 

Problems:
(1) But I cannot select a measure as a legend. I tried to work with field parameters, but failed.
(2) I would like to aggregate by day, week, month as the second step (This functionality exists already)

I tried a couple of YouTube videos for it already, but all did not give me the result


Code to generate the measure cat:

 

 

cat = 
SWITCH(
    TRUE(),
    SUM(z_cat_test[sales]) > 0 && [acos_test] >= 1, "ACoS >= 1",
    SUM(z_cat_test[sales]) > 0 && [acos_test] < 1 && [acos_ppc] >= 0.3, "0.3 <= ACoS < 1",
    SUM(z_cat_test[sales]) > 0 && [acos_test] < 0.3, "ACoS < 0.3",
    SUM(z_cat_test[sales]) = 0, "No revenue",
    "Other"
)

 

 


Here is a link to the data set: 
https://docs.google.com/spreadsheets/d/1DPknFqBUSfle4ioUAeEclBipfSNqKDUXhnCyTEr-r0E/edit#gid=0

Thanks

Need Help

7 Replies

    • haurg's avatar
      haurg
      New Member
      3 years ago

      Sure,

      this is a measure

      acos_test = DIVIDE(SUM(z_cat_test[ad_spend]), SUM(z_cat_test[sales]), BLANK())
      • NaveenGandhi's avatar
        NaveenGandhi
        Icon for Memorable Member rankMemorable Member
        3 years ago

        You can create cat as a column, so that you can use it as a legend.

         

         

        I have removed the second category as i did not know acos_ppc calculation. Also create acos_test using power query, Creating it as a column using dax will create circular dependency.

         

         

        For the 2nd problem, since this a column now, you can aggregate it day, week, month using date column.

         

        Hope this helps! let me know if you have any issues.

         

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