Sam,
Thank you for all the help. I followed the whole thing and clean up stuff and organized stuff as you suggested.
I ended up creating Sum of sales measure, I normally put stuff in the table so I can see how the result looks like. For some reason running total is not showing its value if the current Month doesnt have a count.
Here are my measures
Total Claims = COUNT(Claims[ID])+0
Total By MIS = CALCULATE([Total Claims]|
FILTER(values('Claims'[MISGroup])|
COUNTROWS(
FILTER('BinSelect'|
'Claims'[MISGroup]>=BinSelect[minvalueRange]&&
'Claims'[MISGroup]<BinSelect[MaxValueRange]
))>0))
This is for running total.
Running Total By MIS = CALCULATE(
[Total By MIS]|
FILTER(
ALLSELECTED('Claims'[MISGroup])|
(ISONORAFTER('Claims'[MISGroup]| MAX('claims'[MISGroup])| DESC)
)
))
Also The IPTV formula, somehow needs to be changed to just use MISGroup=3 Which I cant figure out yet
Here is the fomula again that you help me create. I had to add the measure for sales as it was printing all the dates from the date table.
IPTV =
IF(ISBLANK([Total By MIS]) && [Sum of Sales]=0 |
0
|Divide([Running Total By MIS]|[Sum of Sales]|0)*1000
)
I was watching one of your videos and you mentioned that the reason it shows “blank” cause it is out of the context. I am not sure what I am missing. If I can do the 0 only for 3 MISGroup and be able to move running total working I should be much closer to my desire result.
I tried to resolve it by following your post and had no luck
Again thank you for your help.