Forum Discussion

GoingIncognito's avatar
GoingIncognito
Icon for Advocate III rankAdvocate 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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
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.