Forum Discussion

gheisenberg's avatar
gheisenberg
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's avatar
    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.

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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.

 

 

 

gheisenberg's avatar
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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Thank you for your message.

    I tried to create Bin_V2 table like below, and used Bin_V2[Range] column in the visualization.