Cumulative measure & filters
Hello everyone, I created a graph, like you can see on the picture. I created the 2 curve by using the command "New visual calculation - Running sum" Everything is working well until I Try to apply filters on my graph ( The blue bars are adapting correctly) . I can Imagine that it is because the running sum is calculated before the the filters and it does not update the values. I also added the tab version of my graph. Does someone have an idea how to resolve this ? Thank you.
Total sum for equal values - measure in Power BI
Hey, I would like to kindly ask for help on writing a measure that will add line by line a variable called “%” I have a table in Power BI: And I need a table with the measure “Total sum” as below: My problem is to calculate the cumulative sum for values that are the same, maybe it is possible to add the ranking per row, where for 17% will be 1 and 2? Thank you in advance for your help!
cumulative count measure per row
hello i need to create a measure that calculates incentive as per below rules Achievement Incentive 1 to 5 count of sales 2$ 6 to 10 count of sales 4 $ 11 to 15 count of sales 6 $ 16 and above count of sales sales 8 $ what this means, if agent has made 15 transactions, he will get incentive of (2$*5) for first 5 transactions, and (4$*5) for next 5 transactions and (6$ *5) the 5 transactions after. so total incentive= 10+20+30=60$ i created below measure = CALCULATE(IF([MNP cumulative count]<=5,[MNP cumulative count]*2,IF([MNP cumulative count]>=6 &&[MNP cumulative count]<=10,[MNP cumulative count]*4,IF([MNP cumulative count]>=11 &&[MNP cumulative count]<=15,[MNP cumulative count]*6,IF([MNP cumulative count]>=16,[MNP cumulative count]*8,0))))) and [MNP cumulative count]= CALCULATE(SUMX(SUMMARIZE('categories trans','categories trans'[AGENT_ID],'categories trans'[AGENT_NAME],'categories trans'[TRANSDATE],'categories trans'[achievement],'categories trans'[Categoty]),[mnp distinct count]), FILTER ( ALLSELECTED('categories trans'), 'categories trans'[TRANSDATE]<=MAX('categories trans'[TRANSDATE]))) my problem is the cumulitve count does not count correctly when agent has 2 transactions in the same day. instead of counting them as 2 it's counting them as 1 also the data i have is as below table agent id agent name transaction value (achievement) date 123 abc 2 1/11/2023 456 def 1 2/11/2023
TotalMTD , TotalYTD is very slow for a specific table
I created following measure in 2 tables, orders and shipments. Both are showing correct value. However measure in orders loads very fast but same measure formula in shipments is extremely slow TOTALMTD( orders[amount], calendar[date]) time : 1524 is very fast but TOTALMTD (ship[amount], calendar[date]) is slow time :6454 calendar is not marked as date table because it is having duplicates. i don't mind, because it is showing correct values
