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.
Hi..
i need help with my measure below..
i am creating a measure for custom calculation.. the criteria is if the created measure has the value greater than '"0" than it should return the spending otherwise blank.. the formula working on row by row is perfectly fine
but for the totals.. it is showing the same amount of spend which is incorrect.. in this case where i am making the mistake.. would be very glad for your expert opinon..
Thanks
Solved! Go to Solution.
Hi @Zainhashmi ,
Please refer to my formula.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zainhashmi ,
Please refer to my formula.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Zainhashmi You could try and add on line 47 (after the RETURN) a SUMX like so:
SUMX(VALUES('Table'[Vendor Name]),
then add another ) at the very end. That way it will figure it out per vendor (you can also do it for each row of the table if you drill down), then sum them up.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
so when i am trying to aggregate it... it doesn't show the formula as seen below:
@Zainhashmi Can you try doing it as a new measure? Verified Total = sumx(values(table[vendor name]),[Verified])
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |