Forum Discussion

GoingIncognito's avatar
GoingIncognito
Advocate III
6 years ago
Solved

Sumx, format and crossfilter

I've a matrix that gets its rows from two tables: a dimension table for instruments traded in stock market and a fact table of of traded stocks. I've no column values in the table, and all the values...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    GoingIncognito ,

     

    Format the measure using dax like pattern below:

    Measure =
IF (
    MAX ( fact[date] ) = CALCULATE ( MAX ( fact[date] ), ALL ( fact ) ),
    FORMAT (
        SUMX ( FILTER ( fact, fact[date] = MAX ( fact[date] ) ), fact[amount] ),
        "### ### ###.#0"
    ),
    BLANK ()
)

     

    Community Support Team _ Jimmy Tao

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

amitchandak's avatar
amitchandak
Super User
6 years ago

It should be

format(sumx(filter(),[measure]))

  • GoingIncognito's avatar
    GoingIncognito
    Advocate III
    6 years ago

    Thank you Amit for declaring the right syntax!

    Finally I solved this with very simple if:

    if(sumx()<>0, sumx(), blank())

     

    now I don't get blank rows. But this still doesn't make sense to me, why I'd get blank rows in the first place.