Forum Discussion

vinoothna9's avatar
vinoothna9
Frequent Visitor
5 years ago
Solved

Relationship/Dax Function

I have a requirement where I have to represent revenue amount in a bar chart and  Fiscal year, Quarter as Slicers. - Revenue Amount is from Revenue table.  - Fiscal year, Quarter slicers are from D...
Need Help
Show and Tell
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi vinoothna9 ,

    The reason that cause this issue is that you diable the date relationship between two tables so that the fiscal year slicer could not work and the visual will show both fiscal years value based on your initial measure.

    You can modify your measure like this:

    Revenue Amount = 
CALCULATE (
    SUM ( 'Revenue Table'[Revenue] ),
    FILTER (
        'Revenue Table',
        YEAR ( 'Revenue Table'[Date] )
            = SELECTEDVALUE ( 'Default Calendar'[Fiscal year] )
    ),
    USERELATIONSHIP ( 'Default Calendar'[Quarter], 'Revenue Table'[Quarter] )
)

    In my sample use the table visual to show the result directly:

    Attached the sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

vinoothna9 , if date of revenue is joined with date of calendar, why to you need to join Quarter?

You should able to get fiscal year, Quarter using date table.

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.