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.

vinoothna9's avatar
vinoothna9
Frequent Visitor
5 years ago

Yes It doesn't require any measure if Revenue[date] is related to Date[Date]. For some reason I don't see revenue Amount in the visual when I have Revenue[Date] related to Date[Date]. The slicers are working fine for other tables/columns except Revenue table.