Forum Discussion

New Member

2 years ago

Solved

Visualising a measure when using a calculated column is not possible

Hi All, I really need your help. In order to illustrate my problem I use the following sample data set: HERE you will find the data set as well as the .pbix file I am using: https://th-koeln.s...

Jihwan_Kim
2 years ago
Hi,

I am not sure if I understood your question correctly, but please try something like the attached pbix file whether it suits your requirement.

zscore-test.pbix42 KB

gheisenberg

New Member

2 years ago

Thank you very much for your great help. It seems to be exactly what I need. I am not sure that I fully understand how you sloved it. Would it be ok if you explain your solution in a few words?

expected result measure: = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE (
                'values',
                'values'[name],
                'values'[industry],
                'values'[sector],
                'values'[value1]
            ),
            "@zscore", [zscore val1]
        ),
        [@zscore] >= MAX ( Bins_V2[Min] )
            && [@zscore] < MAX ( Bins_V2[Max] )
    )
)

Thank you very much again. Gernot