Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm new to PowerBI, any help would be greatly appreciated! For ease, I have attached a dummy .pbix file with dummy data. You can download it via the link below:
https://drive.google.com/file/d/1RJ_wS1KiabRhuZFlwj4WzXz4ZVNFdwCz/view?usp=sharing
Introduction:
There are four tables in my data, with the following notes:
Goals:
I want to segment my Invoices and Works to different System types.
Questions:
Question 1:
Question 2:
I have spent a lot of time on trying to get this done, so I would greatly appreciated any help!
Thanks in advance!
@Anonymous , Based on what I got, measure like
Sumx(Summarize(Table, Table[Invoice ID]. Table[Work ID]), [Measure])
or
Sumx(Summarize(Table, Table[Invoice ID]. Table[Work ID],"_1", [Measure]),[_1])
Hi @amitchandak, thanks for your quick response. I don't understand it though. Could you be so kind to be a little more specific? In which table should I put the measure? To which tables and measures are you referring? [edit] and which of the two questions are you addressing?
@Anonymous , Why this formula as not considered
Revenue_systemtype m = DIVIDE(sum(Invoices[Amount]), sum(Service_reports[Number of systems]))
Hi @amitchandak, although I appreciate your effort, the suggested measure is not achieving the desired result. Am I missing something here?
Also, are you trying to answer question 1 or question 2?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |