Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone!
To summarize my infos:
WHAT I HAVE: A database that shows when (DATE) a new machine (MACHINE) was added in my mini factoty and its level of importance (LEVEL OF IMPORTANCE) [Check out the picture in the end of this post].
WHAT I WANT: I want to check out the evolution of my machines in my mini factory detailing it by level of importance according when they were bought (DATE) [Check out the picture in the end of this post].
WHAT I'VE TRIED: I've tried this DAX Measure:
Thanks for helping me!
Hi,
The code below should do the trick.
_RT =
var _no = CALCULATE(DISTINCTCOUNT(NewTable[i]), ALL(NewTable[i]))
return
COUNTROWS(FILTER(ALL(NewTable), NewTable[imp] = SELECTEDVALUE(NewTable[i]) && [date] <= MAX(NewTable[date]))) / _no
It does require you to transform your table / add a new version of it:
NewTable = CROSSJOIN(SELECTCOLUMNS(VALUES('Table'[imp]),"i", [imp]),'Table')
In this video I show how to create the dashboard as seen below.
Link to the file here.
Pls mark as solution if so. Thumbs up for the effort are appreciated.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |