Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I was wondering if you can help my in this part. Im trying to aggregate some numbers without summing them. So for each cycle.Name i want to have each type of available numbers for it without summing them. Im sure im overlooking something simple here but not able to get it yet.
Solved! Go to Solution.
@Oceans88 the DAX I gave you should generate the new table you are looking for. When you say "new table" you mean a new calucated table that is in your data model yes?
I am trying to create a dashboard that shows the value of the company by event attended but Power BI keeps summing the value by the number of both Invididual and Event.
See this example:
I wanted to have a summary of the value we delivered to Company just by unique events they have attended and not adding up the value based on the number of attendees.
For Company A, I wanted to see the total value we delivered adding from Founder Fundamentals Group Workshop (250), March 21 One on One (250), and April 21 One on One (250), total of 750. Power BI is adding up two entries from March 21 One on One so total becomes 1000.
Is there a way to de-duplicate this?
Maybe somthing along these lines:
If you drag the field into the visual and set it to 'Don't Summarize' it will group them instead.
This is exactly what i need but i need to create these setup in a calculated table.
Thank you very much for the prompt reply. But i would need to have it made in dax as the numbers im looking for are basis used for another calculation behind the scenes. Visualy i dont need to display them anyware. Would you know how to produce same results by using dax?
THnak you & Kr
I think this will give you what you are looking for.
Cycle Breakup Measure =
SUMX (
GROUPBY ( YourTable, YourTable[Cycle.Name], YourTable[Cycle.Breakup] ),
YourTable[Cycle.Breakup]
)
Hi thanks again for looking into it. Im more looking for the first example you provided at the begining but would need it in the form of a Calculated table i dont need the Sum of all the numbers like your last example.
@jdbuchanan71 I am sorry i guess i was missing the Calculated table portion adn did not explain correctly.
Oh, for that you can just do
New Table >
New Table = SUMMARIZE ( YourTable, YourTable[Cycle.Name], YourTable[Cycle.Breakup] )
@Oceans88 the DAX I gave you should generate the new table you are looking for. When you say "new table" you mean a new calucated table that is in your data model yes?
You are 100% correct. Its my mistake. I just checked the table and it works perfectly. I overlooked that since the numbers on breakup are numerical values they get sumed up automaticaly when creating a table on a page.
Many thanks for your help. Greatly apreciated.
Kind regards.
Hi , thank you for the dax, but its summing the breakup still, we need it to be not summing the breakup. Do you know how i could acheive that?
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |