Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I'm new to the Power BI Community and have problem in setting up a measure to combine the values to be used as the denominator in calculating % in the table below. I need to sum "PO-FMS" and "PO-PDS" in Docu_Type column to a new group called "PO". Could anyone show me how to do such measure? Thank you!
Client | Docu_Type | Inv Amt | Status |
ABC | PO-FMS | $100 | Transferred |
ABC | PO-PDS | $200 | Ready |
A235 | Contract | $300 | InFlow |
B388 | Other | $400 | Transferred |
02345D | WO | $550 | Cancelled |
ABC | PO-FMS | $660 | Cancelled |
DEF | PO-PDS | $770 | Cancelled |
etggg | Contract | $880 | InFlow |
23425 | Other | $990 | Ready |
223333 | WO | $1,000 | Transferred |
DEF | PO-FMS | $1,100 | InFlow |
ABC | PO-PDS | $1,200 | Ready |
Solved! Go to Solution.
create a dimension like the below and relate it to the main table and then drop NewType to the rows of the matrix
Inv Amt | New Type |
PO-FMS | PO |
PO-PDS | PO |
Contract | Contract |
Other | Other |
WO | WO |
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
create a dimension like the below and relate it to the main table and then drop NewType to the rows of the matrix
Inv Amt | New Type |
PO-FMS | PO |
PO-PDS | PO |
Contract | Contract |
Other | Other |
WO | WO |
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thank you so much @LivioLanzo I didn't think of creating a new table to relate the new value type to the old one and then using it in the visualization. Now problem solved. Thanks again!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
61 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
103 | |
77 | |
71 |