locked
Issue in implementing Measures using DAX RRS feed

  • Question

  • Hi,

    Using Contoso Sales file in PowerBI desktop.

    1. How to check the output of New measure created :

    PreviousQuarterSales = CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSQUARTER('Calendar'[DateKey]))


    2. Dragging this measure on Report Canvas is not producing any visual. 

    3. Also do we have some other group of PowerBI as after selecting Forum Category as Power BI, there are only 2 options coming in Forum : Power Pivot, Power Query.

    Can anybody please help me on above queries. Thanks.

    Tuesday, December 4, 2018 8:18 AM

Answers

  • Hi,

    I guess, this measure make sense only with dates on the visual. I've got correct result with matrix (Year on Columns, MonthName and QuarterOfYear on Rows). Unfortunately, inserting images is not allowed for me yet.

    Wednesday, December 5, 2018 4:59 PM
  • As Aleksei mentioned, for question #1 you need to add a date filter to calculate this measure. You can also add that measure as the card visual, then see the value populated when you select a year through any viable means (slicer, selecting in a chart, etc.).

    For the question about where to post these questions, I'd suggest you post them directly on the Power BI Community Forums since these have a lot more traffic and sub-folder/topic areas.

    https://community.powerbi.com/t5/Forums/ct-p/Forums

    Thanks,
    Sam Lester (MSFT)


    https://blogs.msdn.microsoft.com/samlester/

    Twitter - @SQLSamLester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Monday, December 10, 2018 11:10 PM

All replies

  • Hi,

    I guess, this measure make sense only with dates on the visual. I've got correct result with matrix (Year on Columns, MonthName and QuarterOfYear on Rows). Unfortunately, inserting images is not allowed for me yet.

    Wednesday, December 5, 2018 4:59 PM
  • As Aleksei mentioned, for question #1 you need to add a date filter to calculate this measure. You can also add that measure as the card visual, then see the value populated when you select a year through any viable means (slicer, selecting in a chart, etc.).

    For the question about where to post these questions, I'd suggest you post them directly on the Power BI Community Forums since these have a lot more traffic and sub-folder/topic areas.

    https://community.powerbi.com/t5/Forums/ct-p/Forums

    Thanks,
    Sam Lester (MSFT)


    https://blogs.msdn.microsoft.com/samlester/

    Twitter - @SQLSamLester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Monday, December 10, 2018 11:10 PM