Need Help Inserting a Specially Formatted Table

[Anonymous]

Hi everyone,

Is it possible to place this type of table into Power BI? I would need the table to calculate one set of values, but with different formulas above and below the grey line. 

Example: Above the grey line needs to be values calculated by Formula #1 and below would calculated by Formula #2 (using the same set of values)

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may go to 'Query Editor', click 'Add Column'=>'Index Column'.

Then you may create a measure as below. The measure is to calculate the sum of each column value for each row. You may replace 1,0 with formula1 and formula2.

Result = 
var _index = SELECTEDVALUE('Table'[Index])
var _cash = 
IF(
    CALCULATE(
        SUM('Table'[Index]),
        FILTER(
            ALL('Table'),
            ISBLANK('Table'[Cash Mgmnt])
        )
    )<_index,
    1,0
)
var _finance = 
IF(
    CALCULATE(
        SUM('Table'[Index]),
        FILTER(
            ALL('Table'),
            ISBLANK('Table'[Finance])
        )
    )<_index,
    1,0
)
var _legal = 
IF(
    CALCULATE(
        SUM('Table'[Index]),
        FILTER(
            ALL('Table'),
            ISBLANK('Table'[Legal])
        )
    )<_index,
    1,0
)
var _loanops = 
IF(
    CALCULATE(
        SUM('Table'[Index]),
        FILTER(
            ALL('Table'),
            ISBLANK('Table'[Loan Ops])
        )
    )<_index,
    1,0
)
return
_cash+_finance+_legal+_loanops

Result:

Best Reagrds

Allan

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

[Anonymous]

@v-alq-msft This is great thank you so much for your help! Appreciate it

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490