Hi @GuestUser ,
the same problem is described here.
Unfortunately, the SELECTEDVALUE solution is only available from SSAS 2017.
@Thanks for your inputs!!
Used below formula(similar)..replaced selected value by hasonevalue and it worked..
Measure = CALCULATE ( [Sales], FILTER ( ALLSELECTED ( 'Table'[Category] ), 'Table'[Category] <= SELECTEDVALUE ( 'Table'[Category] ) ) )
Hi @GuestUser ,
I am glad that your problem has been resolved, you could accept your own reply to close the case.
facing some strange behaviour
the below formula works
Cumulative = calculate( table[total sales],
when i dont put any filter condition on total sales..cumulative value is correct...but it shows item with no sales as well
So when i put filter condition as total sales is not blank in report ,
then the cumulative value shows wrong value..it shows correct for 2 records..then the third record..it shows the same value as total sales
Any suggestions pls?
First screenshot is without any filter condition added -- it giving correct result
Second one - Added filter condition on filter pane ..like trx count is not blank...it gives incorrect result
basically i do not need those items in the report with trx count blank
Any suggestions pls
1) Cumulative = calculate( table[trx count],
2) Trx Count = sum(table.item_count)
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.