Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 when I change the date slider.
As you can see in the image below, I can get these to display in table format. However, it won't let me add my measures as values to other visuals such as the pie chart.
Does anyone know why this is?
Thanks in advance
Hi, I'm having same problem any Idea how to solve this ?
My measurment:
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |