Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Find Promotion effectiveness in Power BI

I have an excel file which have data for certain  meals.

Columns are "emailer_for_promotion" and "homepage_featured" which contains values 0 or 1 .1 means

Yes and 0 means no.

 

Now i want to show analysis for both "emailer_for_promotion" and "homepage_featured" .

I have created donut chart showing yes or no percentage for both "emailer_for_promotion" and "homepage_featured" .

 

But as 0 are more i.e NO occurences are there and Promotion is done for certain time period.It would be unfair to do comparison against the whole data.

Let me know if there is any dax function so that i can do an equal comparison .

 

I'm attaching the excel files and Power bi File.

There are 3 sheets in excel file containing all data.

 

Excel file- Link 

Power Bi File - Link 

Thanks!

data protection
Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Since I still not so clear what you wanted, can you please example more about these or share some expected results?

    How to Get Your Question Answered Quickly 
    In addition, you can try to use the measure formula with filters to limit the calculation ranges and records to get a smaller rate of 'no' records.

    Filter Arguments in CALCULATE 

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous,

       

      suppose on feb 6 2020 and feb 13 2020 promotion was done but on feb 20 promotion was not done.

      So i dont want to include the feb 20 date.i only want those dates where there was yes and no both so that a fair comparison is done.

      If i use the filter pane to filter the dates , first i have to look into data where there was no promotion and then filter it manually.

      And here there are lot of records so these is not feasible.

      So i want a dax fn that sees if there are "yes" and "no" values on a date and that does not considers the date having only 1 value on a date.

       

      Thanks!

       

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Anonymous,

        You can use summarize and countrow functions to get the detailed scenario of current records.

        Below is the sample formula about extracting the records who has both two status. You can add these to your formula as a variable to filter records that not exist on the list.

        VAR summary =SelelctColumns(
    FILTER (
        SUMMARIZE (
            ALLSELECTED ( Table),
            [Date],
            "DC Status", COUNTROWS ( VALUES ( Table[Status] ) )
        ),
        [DC Status] = 2
    ),"Date", [Date])

        Regards,

        Xiaxoin Sheng