Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have problem with show the correct data on the graphs. I'm using measrue:
Solved! Go to Solution.
Hi @Jacekk111 ,
Glad you solved the problem by yourself! If you don't have other problems, would you mind accept your reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Kaly
Hi @Jacekk111 ,
Glad you solved the problem by yourself! If you don't have other problems, would you mind accept your reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Kaly
Unfortunatly this not working as should be:
The point line should be differ depending on area
I figoure out by creation properl agregation in power query as individual table and next conected by model.
Thank You, but maybe I wasn't precise in my descritption as I should be. In column "Daily Output" I have daily production that is refere to every ID scrap input. If I use sum function I got sum all Scrap row but I need only sum up 1 daily output refers to area and date. In my fuction VALUES function makes to delete the same values (2511) but It should be sum up beacuse this is different day.
Is this what you are looking for?
DesiredOutput =
SUMX (
SUMMARIZE (
SCRAP,
SCRAP[Area],
SCRAP[Date],
"Value", DISTINCT ( SCRAP[Daily Output] )
),
[Value]
)
Can you try:
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |