Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Good day,
How can i create the "Table in report view What i want" with the data set ?
Solved! Go to Solution.
HI,
I am not sure if I understood your question correctly, but please try to create an explicit measure, something like below.
Numbers expected result measure: =
VAR _t =
SUMMARIZE (
Data,
Data[Category],
Data[Numbers]
)
RETURN
SUMX (
_t,
Data[Numbers]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi
Jihwan_Kim
The formula worked perfect for the first Data [number] table but when used for the the second table (lets call this Data [number2]) the system sums something else up.
The total value expected is around 14 but the system gives a number of 73.
I dont know if the following info about Data[number2] might help.
Data[number2] is created via a formula in power BI.
Could this be a reason why the system provides another value ?
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
If you want to use the measure, not the column, inside your expected result measure, please try something like below.
expected result by using Numbers measure =
SUMX (
DISTINCT ( Data ),
[Numbers measure:]
/ CALCULATE (
COUNTROWS ( Data )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan_kim,
I was not able to confirm yet if it works. After the weekend i will be back and in office and confirm.
I am trying to send the pbix file and excel file, but the system does not accept it. Idk why.
This formula is not providing the expected results.
Attached a snip of the files.
I hope that you can guide me with this info
Hi, please share the link of your sample pbix file, for instance, onedrive link, dropbox link. or others.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan_Kim,
Attached is the link
https://drive.google.com/drive/folders/14b5tKuw7zcbbfhDogbscLqmhZHeJpWF8?usp=drive_link
Hi,
I do not have access. 😥
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan_Kim,
Apologies. Still learnig.
The request to share the folder has been received and also accepted.
HI,
I am not sure if I understood your question correctly, but please try to create an explicit measure, something like below.
Numbers expected result measure: =
VAR _t =
SUMMARIZE (
Data,
Data[Category],
Data[Numbers]
)
RETURN
SUMX (
_t,
Data[Numbers]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Jihwan_Kim
Yes thank you. It works perfect.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |