Forum Discussion

kmcd's avatar
kmcd
Frequent Visitor
9 years ago

Area Chart Interactions

I have an area chart which shows target sales and actual sales against month.   The targets table has the columns: Team Month Target Whilst the sales table has the columns: SaleID SaleDate...
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

kmcd You can create dax measure using below and use that for target in visual. So when applying any filter won't have any effect on that.

 

=CALCULATE( SUM('YOURTABLE'[targetColumn]), ALL('YOURTABLE'))

  • kmcd's avatar
    kmcd
    Frequent Visitor
    9 years ago

    ankitpatira thanks for the reply. I tried your DAX and it resolves the filtering issue but fixes the annual target value as target for each month. Using ALL('YOURTABLE'[targetColumn]) instead of ALL('YOURTABLE') resolved this but the filtering reverts back to my original problem.

     

    Any ideas?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi kmcd,

      Could you please share sample data of your tables and post the expected result here? We will appreciate that if you can share the PBIX file.

      Thanks,
      Lydia Zhang

      • kmcd's avatar
        kmcd
        Frequent Visitor
        9 years ago

        Hi Anonymous, I cannot share the original file as the data is commercially sensitive. However I have created a sample workbook with random data although it is behaving slightly differently. How/where do I upload the PBIX file?