Forum Discussion

kongyuancn's avatar
kongyuancn
Icon for Helper II rankHelper II
6 years ago
Solved

Get average on rows continas no blank

Hi All, I'm trying to get compare benchmark on different software stack. Here is a simple data set:   System       Stack1 Stack2 Stack3 Stack4 System1 1 4 6   System2 2 5     ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi kongyuancn ,

     

    Try to create a measure like this and put it into visual level filter.

    IgnoreNullValues = IF (
                        CALCULATE(DISTINCTCOUNT('Table'[Stack]),ALLSELECTED('Table'[Stack]))
                        = COUNTROWS(ALLSELECTED('Table'[Stack])), 
                        MAX('Table'[Benchmark]
                       ))

    Sample .pbix

     

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

speedramps's avatar
speedramps
Icon for Super User rankSuper User
6 years ago

Hi Kong

 

Please consider this solution

 

Create your Benchmark table

System

Stack1

Stack2

Stack3

Stack4

System1

1

4

6

 

System2

2

5

  

System3

3

 

7

 

System4

8

8

10

11

System5

12

13

14

 

 

Right click the  System column and Unpivot other columns

Rename Attribute to Stack#

 

Create DAX measures:-

Total score = SUM(Benchmarks[Value])                                      --  total score

NO stacks = COUNTROWS(Benchmarks)                                    --  number of stacks

Ave benchmark = DIVIDE([Total score],[NO stacks],BLANK())       --  average

 

Create a table report with:-

System

Total score

NO stacks

Ave benchmark

 

 

 

 

 

 

  • kongyuancn's avatar
    kongyuancn
    Icon for Helper II rankHelper II
    6 years ago

    Thnak you speedramps  for your quick response. But I think your solution is incorrect. I want to calculate the station based on the systems those have benchmarks on ALL of selected stacks.