Table in the report view not to my expectations

[Riaz02]

Good day,

How can i create the "Table in report view What i want" with the data set ?

[Riaz02]

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 ?

[Jihwan_Kim]

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 )
        )
)

[Riaz02]

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. 

[Riaz02]

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

[Jihwan_Kim]

Hi, please share the link of your sample pbix file, for instance, onedrive link, dropbox link. or others.

Thank you.

[Riaz02]

Hi Jihwan_Kim,

Attached is the link

https://drive.google.com/drive/folders/14b5tKuw7zcbbfhDogbscLqmhZHeJpWF8?usp=drive_link 

[Jihwan_Kim]

Hi,

I do not have access. 😥

[Riaz02]

Hi Jihwan_Kim,

Apologies. Still learnig.

The request to share the folder has been received and also accepted.

[Jihwan_Kim · Accepted 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]
    )

[Riaz02]

Jihwan_Kim

Yes thank you. It works perfect.