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)
This will be a conference that you do not want to miss!
Don't miss the Power BI Dev Camp this week!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.