Forum Discussion

brettg's avatar
brettg
Icon for Helper II rankHelper II
8 years ago

Use measure as value in visual e.g pie chart

Hi All,   Is it possible to use measures as values in visuals such as pie charts, scatter graphs..   I have created measures for the latest test and latest result of each user, and these update w...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi brettg

I can't reproduce your problem, how do you calculate the measure?

 

Best Regards

Maggie

  • brettg's avatar
    brettg
    Icon for Helper II rankHelper II
    8 years ago

    Hi Maggie,

     

    Thank you for taking the time to look into this for me.

     

    This is the measure I am currently using to get the latest result per user:

     

    Latest Result =

    VAR User = SELECTEDVALUE('Table'[User])

    VAR MaxTest = MAXX(
    KEEPFILTERS(VALUES('Table'[User])),
    CALCULATE(MAX('Table'[Test Date]))
    )

    RETURN

    CALCULATE(SELECTEDVALUE('Table'[Result]), ALLSELECTED('Table'),'Table'[User] = User, 'Table'[Test Date] = MaxTest)

     

    I'm assuming I need a True or False IF statement now to bring back if its the latest test?

     

    Many Thanks,

    Brett