Forum Discussion

GuestUser's avatar
GuestUser
Helper V
6 years ago
Solved

Cumulative dax query help

Hi We are using power bi with ssas tabular model using connect live option. Need help in cumulative column Report format is as below Matrix view Year. 2018. 2019 Item. Trxcount. Cumulative T...
Need Help
  • GuestUser's avatar
    GuestUser
    6 years ago

    Hi mwegener 

     

    @Thanks for your inputs!!

    Used below formula(similar)..replaced selected value by hasonevalue and it worked..

     

    Thanks !!

    Measure =
CALCULATE (
    [Sales],
    FILTER (
        ALLSELECTED ( 'Table'[Category] ),
        'Table'[Category] <= SELECTEDVALUE ( 'Table'[Category] )
    )
)

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi GuestUser ,

 

try this.

 

Cumulative Trx = 
CALCULATE(
	[Trxcount],
	FILTER(
		ALLSELECTED('Item'[Item]),
		ISONORAFTER('Item'[Item], MAX('Item'[Item]), DESC)
	)
)

 

 

PBIX

 

GuestUser's avatar
GuestUser
Helper V
6 years ago

Hi mwegener 

 

While using MAX function , i get the error ...max function can work only on numbers or dates and not string data types

I am using Connect Live (SSAS Tabular)

 

just for trying....I checked on pbix file where  import method was used ...it works there...

Any idea ..why is it so??

 

Any suggestions on how to implement in connect live?