The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have primary and secondary data in 2 columns. I need to present them on one axis and to be collected (summed) automatically once presented on the graph. for example, I have 10 TT, I need to be automatically counted to be 12 (i.e. to reflect the total numbers) as well as
Business Model | 2ndry Business Model |
TT | - |
TT | - |
XYZ | - |
TT | TT |
XYZ | - |
XYZ | - |
Commercialization | - |
Commercialization | - |
XYZ | - |
XYZ | - |
XYZ | - |
XYZ | - |
XYZ | - |
XYZ | - |
XYZ | - |
TT | Commercialization |
TT | Commercialization |
TT | Commercialization |
TT | - |
TT | - |
Commercialization | - |
TT | - |
TT | - |
Commercialization | - |
Commercialization | XYZ |
Commercialization | - |
Commercialization | - |
XYZ | TT |
Solved! Go to Solution.
Hi, @drahmedsalem
In addition to the methods mentioned above, you can also clean the data directly in PQ, so that the report will be made faster.
You can get two single lists through 'reference', then unify the names for append operation.
If you still have problems, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @drahmedsalem
In addition to the methods mentioned above, you can also clean the data directly in PQ, so that the report will be made faster.
You can get two single lists through 'reference', then unify the names for append operation.
If you still have problems, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
create new table.
Business = distinct(union(distinct(Table[Business Model]), distinct(Table[2ndry Business Model])))
Join these two columns with new table. One join will active assume (Business Model one), and one will be inactive
then try measure like this with Business Model from Business Model
count(Table[Business Model]) + calculate(count(Table[2ndry Business Model]), userelationship(Table[2ndry Business Model] , Business[Business Model]))
Thanks @amitchandak for your reply.
Regarding the second equation,
Thanks.