Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

banding - count

Hello, from a DirectQuery, I get a table named as tblPerformance which has columns like: pKey Performance asd 10 gfd 34 xyz 39 ... I have manually created a table for banding as follows: tblB...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    Try to count it directly:

    Measure = 
COUNTAX(
    FILTER(
        'tblPerformance',
        [Performance] >= SELECTEDVALUE(tblBanding[Low]) && [Performance] <= SELECTEDVALUE(tblBanding[High])
    ),
    [pKey]
)

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

The reason that you cannot quote tblPerformance[Performance] in the filter formula in tblBanding is that there is no relationship between these tables.

You can try this measure:

 

count =
VAR tab =
    SUMMARIZE (
        'tblPerformance',
        'tblPerformance'[Performance],
        'tblPerformance'[pKey]
    )
RETURN
    COUNTAX (
        FILTER (
            tab,
            [Performance] >= SELECTEDVALUE ( tblBanding[Low] )
                && [Performance] < SELECTEDVALUE ( tblBanding[High] )
        ),
        [pKey]
    )

 

tblPerformance in my sql server database using direct query in power bi desktop:

tblBanding by entering data manually using import mode in power bi desktop:

 

Using a table visual to show the final result:

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi, what does the word tab do in the filter? I thought it should be a table instead?

Thanks