The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hey All
Would appreciate help with this one.
I have a table with Vendor Ledger data that is a combination of a couple of business units.
I use the following measure to calculate the RoSIEInv% and it works fine for the overall calculation, but when I use the slicer, the % calculated is not correct. (See attachment)
The weird thing is that I am using the same formula in the same table for the EDI Inv% calculation, and it works just fine when I use the slicer to see the data for a specific unit.
Solved! Go to Solution.
Thanks for your reply Amitchandak
I got to the bottom of the issue.
My formula was using an incorrect measure [RoSIE Inv] that was not linked to the slicer table to calculate the % instead of another measure named [RoSIE Proc] that is part of the table linked to the slicer (I hope I said that correctly :-))
I would love to accept your comments as a solution, but it was really me who attempted to apply an incorrect measure. Thank you though for showing me an alternative measure to the one that I applied to my model.
Cheers
DeonDP
@DeonDP , I am accepting your reply as solution. Good that you are able to find the issue. Kudos to you.
@DeonDP , Can you share the formula of [Total Invoices] and [RoSIE Inv] .
Also try with divide
RoSIE Inv% = FORMAT(divide([RoSIE Inv],[Total Invoices]), "#,##0 %")
Thanks for your reply Amitchandak
I got to the bottom of the issue.
My formula was using an incorrect measure [RoSIE Inv] that was not linked to the slicer table to calculate the % instead of another measure named [RoSIE Proc] that is part of the table linked to the slicer (I hope I said that correctly :-))
I would love to accept your comments as a solution, but it was really me who attempted to apply an incorrect measure. Thank you though for showing me an alternative measure to the one that I applied to my model.
Cheers
DeonDP
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
115 | |
33 | |
30 | |
24 | |
21 |