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.

dobregon's avatar
dobregon
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi vinoothna9 
Other solution (but not good about optimization) is that you can create a calculated column in the calendar table or in your principal table and take the revenue values

Revenue = calculate(max(revenuevalue), filter(tablerevenue, tableorigin[date] = tablerevenue[date]))

And then you can do a measure with the sum of revenue